c# - 带有 NOLOCK 的 Entity Framework

Question

如何在 Entity Framework 上使用 NOLOCK 函数？ XML 是做到这一点的唯一方法吗？

Answer 1

不，但您可以启动交易并设置 isolation level to read uncommited 。这本质上与 NOLOCK 的作用相同，但它不是在每个表的基础上执行此操作，而是对事务范围内的所有内容执行此操作。

如果这听起来像您想要的，那么您可以按照以下方法进行操作...

//declare the transaction options
var transactionOptions = new System.Transactions.TransactionOptions();
//set it to read uncommited
transactionOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
//create the transaction scope, passing our options in
using (var transactionScope = new System.Transactions.TransactionScope(
    System.Transactions.TransactionScopeOption.Required, 
    transactionOptions)
)

//declare our context
using (var context = new MyEntityConnection())
{
    //any reads we do here will also read uncomitted data
    //...
    //...
    //don't forget to complete the transaction scope
    transactionScope.Complete();
}