Good in-memory database for .net/PowerShell?

For small data ( less then few GBs ) you can use a RAM disk, and use any usual storage ( SQ DB, NoSQL DB, or even a text file), to store data, as usual.

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