entity-framework - MS SQL Azure 内存中的 Entity Framework

Question

是否可以在 Azure MS SQL 数据库上的 Entity Framework 内存中使用？

Azure 在内存中拥有 MS SQL 数据库:In merory Azure

如果可以的话，有什么缺点吗？

Answer 1

是的，如果您完全满足以下条件，就可以使用 EF。

Databases that are at a Premium service tier.

Databases that were created after the In-Memory OLTP features became active.

A new database cannot support In-Memory OLTP if it is restored from a database that was created before the In-Memory OLTP features became active.

Transact-SQL Constructs Not Supported by In-Memory OLTP

Memory-optimized tables, natively compiled stored procedures, and user-defined functions do not support the full Transact-SQL surface area that is supported by disk-based tables, interpreted Transact-SQL stored procedures, and user-defined functions. When attempting to use one of the unsupported features, the server returns an error.

New Features and Enhancements in SQL Server 2016

Support for Multiple Active Result Sets (MARS): In-Memory OLTP now supports MARS using queries and natively compiled stored procedures. This enables requesting data from multiple queries without the need to retrieve each result set before sending the next request. MARS will need to be explicitly enabled in a connection since its disabled by default. With support for MARS, Entity Framework will be easier to implement with In-Memory OLTP.

耐用吗？

They are fully transactional, durable and can be accessed using T-SQL statements just like the disk-based tables. One version of the table is stored in the active memory and the standard version is stored on the hard disk. Transactions, however, only access data directly from the version in the memory and hence run faster.