良好的可扩展容错内存数据库，对.NET具有LINQ支持 [英] Good scalable fault-tolerant in-memory database with LINQ support for .NET

问题描述

是否有支持LINQ和SQL Server持久性的良好的内存事务数据库?我想在内存中创建一个大型数据存储的完整表示形式，并以一种惰性的方式将其提交到SQL Server数据库，但仍可以通过水平扩展将其保留在一定程度的容错能力.我不想依赖像CouchDB这样的非关系数据报.

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.

推荐答案

SQLite支持内存数据库具有交易支持，并且具有

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

关于SQL Server的持久性，我认为您可以自己编写一些代码，以进行向后备SQL Server数据库的惰性传输.

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.

这篇关于良好的可扩展容错内存数据库，对.NET具有LINQ支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！