mihsathe
mihsathe

Reputation: 9154

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 source solutions. Thank you.

Upvotes: 0

Views: 2411

Answers (5)

Denis Mitrofanov
Denis Mitrofanov

Reputation: 11

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.

Upvotes: 0

Sharique
Sharique

Reputation: 4219

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.

Upvotes: 3

Richard Forrest
Richard Forrest

Reputation: 3616

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.

Upvotes: 0

Shiraz Bhaiji
Shiraz Bhaiji

Reputation: 65361

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

Upvotes: 0

Vilx-
Vilx-

Reputation: 106904

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

Upvotes: 0

Related Questions