I needed to set the transaction isolation level when using Entity Framework 6.x to use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Found this easy way to do it, not sure if it fits your need but it’s one way.
|
1 2 3 4 5 6 7 |
public partial class MyContext : DataContext { public MyContext() : base("Name=MyConnectionStringName") { Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;"); } } |
Just use Database.ExecuteSqlCommand in DataContext constructor.
ktnxbye