Embedded databases for ASP.NET

I need an embedded database solution that can be used from within an ASP.NET application. Unfortunately, it seems that SQL Server compact edition does not support ASP.NET and my web host does not avail me SQL Server. MS Access is an option. But would like to have some better open sour开发者_JAVA技巧ce solutions. Thank you.

There are quite a few options:

1. Sql server compact 4.0. It works with asp.net, check this blog entry.
2. Sqlite, it works well with asp.net, get connection from Sqlite connector site.
3. Firebird. provider, article
4. Db4o
5. VistaDb
6. MySql Embedded

I would recommend Sqlite.

SQLite is very popular. There are several .NET bindings available from 3rd party vendors.

SQL Server Express Edition is an option, but it may not be appropriate for high volume sites as it has a connections limit.

You can use SQllite which is a file based small scale database. It does have limitation however.

Sql express still needs to be installed on the server so you would have to check the hosting provider.

If you don't mind against network database model, you can try this: https://github.com/mdsoftware/mData. Lisp-like data processing language and expression compiler/execution machine are an options.