2

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.

Keith Adler
  • 20,880
  • 28
  • 119
  • 189

2 Answers2

1

SQLite supports in-memory databases has transaction support and has a Linq provider as well.

As for the SQL Server persistance, I think you would be on your own to code up something for doing lazy transfers to a backing SQL Server database.

Community
  • 1
  • 1
Eric Petroelje
  • 59,820
  • 9
  • 127
  • 177
0

SQL Server with an ORM tool and possibly a caching solution.

James Westgate
  • 11,306
  • 8
  • 61
  • 68