Small SQL Engine

[RedSon]

Can anyone suggest a small SQL engine that I can embed in an executable or use as a dll? It needs to be compatible with .net framework 2.0 at least. I need a solution where I can just distribute an .exe and run it on any windows machine without worrying about installing SQL Server Express or MSDE?

I'm using SQL Mobile and my application is only 800k, but due to licensing restrictions you have to install at least SQL Server Express. I cannot think why it would be necessary to install 40MB of applications to run a small little app! So I need another solution but can't find one.

The entire project is available at www.codeplex.com/simplebook

[ck9663]

Can't you go XML?

-- CK

[RedSon]

Can't you go XML?

-- CK

I guss I could but how can you do SQL queries on XML.

[ck9663]

XML Dom
XPath
XQuery

Are some of the things you can check out. Here's more.

-- CK

[RedSon]

XML Dom
XPath
XQuery

Are some of the things you can check out. Here's more.

-- CK

It's not for web design though, so not sure how w3schools are going to help. But I'll check out the keywords you listed.

[ck9663]

Those are pretty much generic when it comes on how they treat XML. You can check sql-server BOL and they also have some of those technology on how to parse an XML.

Good luck.

-- CK