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.
Asked
Active
Viewed 2,305 times
0
-
As of version 4, asp.net does support sql compact – Joel Coehoorn Jul 01 '11 at 12:55
-
By "not avail me" do you mean that it is just not available or do you mean also that you are not allowed to install it? – Shiraz Bhaiji Jul 01 '11 at 13:00
-
No, I am not allowed to install too.. – mihsathe Jul 01 '11 at 13:07
5 Answers
3
There are quite a few options:
- Sql server compact 4.0. It works with asp.net, check this blog entry.
- Sqlite, it works well with asp.net, get connection from Sqlite connector site.
- Firebird. provider, article
- Db4o
- VistaDb
- MySql Embedded
I would recommend Sqlite.
pseudocoder
- 4,314
- 2
- 25
- 40
Sharique
- 4,199
- 6
- 36
- 54
0
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.
Denis Mitrofanov
- 11
- 2
0
SQLite is very popular. There are several .NET bindings available from 3rd party vendors.
Vilx-
- 104,512
- 87
- 279
- 422
-
@mihsathe - I don't see why not, though I haven't tried it personally. I know that many websites do use it for a data store, although I cannot say what languages they were written in. – Vilx- Jul 01 '11 at 13:04
0
SQL Server Express Edition is an option, but it may not be appropriate for high volume sites as it has a connections limit.
Shiraz Bhaiji
- 64,065
- 34
- 143
- 252
0
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.
Richard Forrest
- 3,567
- 2
- 23
- 32