Hello,

I'm coming from a MS-database world, using Access with VB, and SQL
Server with C#. I'd like to try an opensource database instead of SQL
Server one, but couldn't find answers to some basic questions:
- can Berkeley DB database be stored in a single file, such as Access'
mdb ones ?
- if the answer is negative, in computers which use a program using
Berkeley DB, how is stored the database and is it easily moveable ?
- is there a DbProvider in ADO.Net 2 which works fine with Berkeley DB
? Or a separate one ? I'd like to use the database with C# and benefit
of DB fonctionality of it.

Thanks in advancefor any answer.

Hi Vivien,

Yes.

Berkeley DB does not support SQL, and so I don't believe that ADO.NET
compatibility is achievable directly. It might be worth investigating
the Berkeley DB for .NET project at
http://sourceforge.net/projects/libdb-dotnet, which provides a .NET
wrapper around the Berkeley DB API.

Regards,
Michael.

Thank you very much. I did not know such a spread database could not
support SQL.
One of the goals of my project being to go into detail of my ADO.Net
knowledge, I think I will give a try to Berkeley Db with smaller
projects, under unmanaged C++, or non-GUI C# app (to use portable DB)...