Good in-memory database for .net/PowerShell?

Question

If I have a script that handles state information that's a bit more complex that can be stored in variables, what's the best option for a small in-memory database?

Sqlite is an option, though that would be an external dependency. XML might do, though it's non-relational.

Is there any consensus on a tool for this job?

Answer 1

Considering PowerShell's great support for scripting .NET, how about using an ADO.NET DataSet.

Answer 2

If you need to persist the data across session, consider using SQL Server Compact Edition. I have used it for a number of smallish .NET projects and it generally works like a small, single user SQL Server.

http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx

Answer 3

Check out this post

http://ayende.com/blog/archive/2007/02/25/unit-testing-database-embedded-vs.-in-memory.aspx