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. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

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 ("DBCC USEROPTIONS;").ToList(); var resultLevel = resultsList[11] == null ? "unknown":resultsList[11].Value ; Of course we can use any other custom SQL scripts ...