Portable DB Suggestions?

[Ed K]

You can also use it with Castle.ActiveRecord which makes it even sweeter!

ed ~"Watch your thoughts; they become your words. Watch your words they become your actions. Watch your actions; they become your habits. Watch your habits; they become your character. Watch your character; it becomes your destiny." -Frank Outlaw.

[Jawz X]

I agree. I recently used it for a project and it is great. They are even include LINQ support in the framework for the .NET lib. I'm not sure where they are at with that yet, but SQLite is the way to go. Regards, Frank

[codebozo]

I concur - db4o would be an excellent choice. It is a true OODB, it has a LINQ provider and it's free as long as the project is truly a "personal project".

[Paul Sanders the other one]

Why do you need a database? I wrote just such a utility for myself a year or so back and I just write the whole thing out to a text file whenever a change is made. This takes approximately 0.000 ms on a modern PC. You can download a (free!) copy of Snippets from here: http://www.alpinesoft.co.uk/freebies[^]

Paul Sanders http://www.alpinesoft.co.uk

[User 4448075]

Advantage Database Server is free for up to two local server licenses. It has a small footprint and is more or less completely documented in a single paperback book, yet it has a dot net provider and lots of medium weight capabilities such as transactions, replication, triggers, and debuggable sql scripts. It also has a lot of backward compatibility with xbase data. http://www.sybase.com/products/databasemanagement/advantagedatabaseserver[^]

[myker]

You might take a look at VistaDB too... It's compatible with SQL Server, supports multi-threading concurency, is completely written in managed code, and has an excellent .NET provider. Works with isolated storage and reduced permissions as well, which is a plus for portable apps. Linq support, however, seems to be lacking, but I believe it's a planned feature. Plus, the db engine is less than a 1 MB... www.vistadb.net. ~myker