How to get isolation level in EF for MSSQL?

Question

I am using EF for access MS SQL data with help LINQ. How can I get current isolation level ? For example this code:

var level = 
Database.Connection.UnderlyingTransaction.IsolationLevel.ToString();

give me error - System.NullReferenceException: Object reference not set to an instance of an object.

As I understand - UnderlyingTransaction is null because I don't use any transactions in my LINQ code.

UnderlyingTransaction is a property of connection. What does that have to do with LINQ? — jdweng, Mar 22 '19 at 13:24
If you don't have a transaction, why do you need to isolation level? — Jamie Rees, Mar 22 '19 at 13:24
@JamieRees - just need to understand can I read uncommited data or not ... — Aleksandr Zolotov, Mar 22 '19 at 13:26
Maybe will help [What is the default transaction isolation level in Entity Framework](https://stackoverflow.com/questions/5657145/what-is-the-default-transaction-isolation-level-in-entity-framework-when-i-issue) — Denis Rubashkin, Mar 22 '19 at 13:26
@DenisRubashkin - I don't want to set level, I just want read a value — Aleksandr Zolotov, Mar 22 '19 at 13:28
@MindSwipe - before today I was thinking the same way, but my log give me other information — Aleksandr Zolotov, Mar 22 '19 at 13:30
@Alexander Oh s**t, I posted that comment on the wrong question, my bad. I have multiple open in my browser and this and another got me confused — MindSwipe, Mar 22 '19 at 13:33

Aleksandr Zolotov · Accepted Answer · 2019-03-22T17:11:11.727

I cannot find how to get current isolation level with EF properties or methods , so we can use custom SQL query for that, for example like this:

public class UserOptionsMsSql
{
    [Column("Set Option")]
    public string SetOption { get; set; }

    public string Value { get; set; }
}

var resultsList = 
service.GetDataContext().Database.SqlQuery<UserOptionsMsSql>
("DBCC USEROPTIONS;").ToList();

var resultLevel =  resultsList[11] == null ? "unknown":resultsList[11].Value ;

Of course we can use any other custom SQL scripts ...

How to get isolation level in EF for MSSQL?

1 Answers1