Microsoft Jet Engine Replacement

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?

Re: Microsoft Jet Engine Replacement

orcauser wrote:

> 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/

--
Chris Crowther MBCS
C# Developer
RHD Research Ltd

Re: Microsoft Jet Engine Replacement

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/)?