Microsoft Jet Engine Replacement

[orcauser]

The Microsoft Jet Engine is deprecated. It's probably not a good idea to use
the Microsoft Jet Engine in a new product development with .NET.
What is the replacement for the Jet Engine? Yes, there is the SQL Server /
SQL Server Express combination. But I'm looking for a database which is easy
to deploy and low administration expense. In a VB6 application you can use
the Microsoft Jet Engine. But what should you use in a .NET application?

 

[Chris Crowther MBCS]

SQL Server Express combination. But I'm looking for a database which is easy
to deploy and low administration expense. In a VB6 application you can use
the Microsoft Jet Engine. But what should you use in a .NET application?

SQL Server Compact Edition is about as low administration expense as you
can get within the product family:

http://www.microsoft.com/sql/editions/compact/default.mspx

You could also look at the SQLite .NET port:

http://sqlite.phxsoftware.com/

 

[orcauser]

Thanks for your response.

SQL Server Compact Edition looks nice in terms of low administration
expense. An embedded database is the right way. Sorry, I didn't mention that
we need multi-user access (up to 4 or 5 user). Unfortunately, SQL Server
Compact Edition supports only single user access.

Yes, SQLite .NET could meet the requirements.

Did someone gain experience with an embedded database like SQLite or VistaDb
(http://www.vistadb.net/)?