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.
3
-
As of version 4, asp.net does support sql compactJoel Coehoorn– Joel Coehoorn2011-07-01 12:55:11 +00:00Commented Jul 1, 2011 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– Shiraz Bhaiji2011-07-01 13:00:36 +00:00Commented Jul 1, 2011 at 13:00
-
No, I am not allowed to install too..mihsathe– mihsathe2011-07-01 13:07:10 +00:00Commented Jul 1, 2011 at 13:07
Add a comment
|
5 Answers
SQLite is very popular. There are several .NET bindings available from 3rd party vendors.
1 Comment
Vilx-
@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.
SQL Server Express Edition is an option, but it may not be appropriate for high volume sites as it has a connections limit.
Comments
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.
Comments
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.
