Are there are good in-memory transactional databases that support LINQ and SQL Server persistance? I d like to create a full representation of a large data store in memory and have it commit to a SQL Server Database in a lazy fashion, but still keep some level of fault tolerance by scaling it out horizontally. I don t want to rely on non-relational datagrams like CouchDB.
We re developing a server system in Scala + Akka for a game that will serve clients in Android, iPhone, and Second Life. There are parts of this server that need to be highly available, running on ...