C# acceisble database api (for download w/ an application)

[netsql]

I would like to write an application w/ a db, for something like
outloook or thuderbird. what are some good db "dll's" that I could look at?

Something like hsql, or mdb or dbf? Small, light, all inclusive. (no ms
sql server that is huge, something like a few huyndred K and has all).

tia,
..V

 

[Nicholas Paldino [.NET/C# MVP]]

You could use the classes in the System.Data.OleDb namespace to work
with Access files.

However, I would seriously consider using SQL Express. It's supposed to
be a lightweight version of SQL Server which is meant more for
per-application use, and not for multiple applications.

The good thing about using SQL Express is that you can use the classes
in the System.Data.SqlClient namespace. And if your needs should get to the
point where you need to upgrade to a full version of SQL Server, then you
won't have to change your data access code (they use the same classes).

Hope this helps.

 

[Guest]

The SQLite database engine is only a couple hundred K, is extremely powerful,
and there are ADO.NET providers for both .NET 1.1 and .NET 2.0. There is no
installation required.
Peter