Can you embed a SQL database?

[ljh]

If I am using VB.Net 2005 with SQL Express or Developer edition and want to
embed the db into my project, how do I do that?

I can't find anything on embedding the db into a VB.Net 2005 app
anywhere.....

 

[Greg Young]

Take a look at SQLite .. it should meet your needs http://www.sqlite.org/

You can get managed providers for it here ...
http://sourceforge.net/projects/adodotnetsqlite

Cheers,

Greg Young
MVP - C#

 

[ljh]

"Supports databases up to 2 terabytes (241 bytes) in size." Holy crap!!
Awesome! Makes MS SQL's 4GB look miniscule by comparison.

But, is it as easy to use in the IDE as MS SQL?

 

[Greg Young]

Never tried .. I generally use object persistence with it

Cheers,

Greg Young