Does SimpleRepository support any in-memory or other "alternative" database engines?

Question

I am looking for options other than MS SQL Server/Express. There seem to be quite a few file based or in-memory database engines supporting some subset or dialect of SQL. Preferably it would be an engine not requiring installation at all.

Is any of them supported by SimpleRepository? Is any of them supported by ActiveRecord? Is there at least some partial support for any of these alternative engines?

Answer 1

Are you looking for a Database engine, or a Query Engine, or an Object Relational Mapper?

Database engines you can use

• MS SQL
• SQLite
• MySql
• Oracle
• PostgreSQL
• CouchDB

Query Engines/ORMs, you can use

• SubSonic
• Linq-to-Sql
• Hibernate/NHibernate
• ADO.Net
• Entity Framework

And countless others. If you're doing .Net development, take a look at SubSonic. Rob Conery and the other contributors are working on some amazingly cool stuff that you might be looking for, like the SimpleRepository and ActiveRecord (almost like a rails style type of data modeling/persistence type of deal).