Linked Questions

I am using Entity Framework 6 in an MVC 5 project. As you're aware of, SELECT queries in SQL Server perform faster and more efficient if we use WITH (NOLOCK) in them. I checked out a few SQL SELECT ...

Possible Duplicate: Entity Framework with NOLOCK I'm using EF4 and .Net 4 to load some XML from a file into a database. I have a class the wraps around the ObjectContext and has methods that add ...

With the new async/await keywords in C#, there are now impacts to the way (and when) you use ThreadStatic data, because the callback delegate is executed on a different thread to one the async ...

What's the difference between using "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" and NOLOCK? Is one better than the other?

I have Entity Framework (.NET 4.0) going against SQL Server 2008. The database is (theoretically) getting updated during business hours -- delete, then insert, all through a transaction. Practically, ...

I have an OData service (WCF Data Service using Entity Framework). All this service does is select data. (No writes EVER.) When I run my OData queries, I am occasionally getting errors like this: ...

I am trying to use TransactionScope in my SELECT query in EntityFramework Core 2.0. However I am getting this error : "Enlisting in Ambient transactions is not supported." The idea is to implement "...

I have a problem where one of my Entity Framework (EF) queries is taking a very long time to execute in Sql Server, although when I copy-and-paste the generated TSQL into Sql Server Management Studio (...

What am I missing? I'm trying to read with NOLOCK using a TransactionScope like this: var scopeOptions = new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }; using (var scope =...

I heard that SQL Server SELECT statements causing blocking. So I have MVC application with EF and SQL Server 2008 and it shares DB with another application which is very frequently writes some data. ...

ASP.NET MVC project 4.5 and EntityFramework Database First. I have some command, which will be triggered when the user clicks a button using (TransactionScope scope = new TransactionScope()) { ...

Occasionally, while debugging some older application code, we receive an exception. This is the offending line of code: XMLReferenceSequence lastXml = (from xml in _entities.XMLReferenceSequences ...

I have a c# entity framework application. I am trying to run a stored procedure from code (no problem with that). its long running, around 30 mins. I write a log of each transaction to a SQL table as ...

I'm working with a system using Entity Framework, and I'm wrapping a call in a TransactionScope but only because I want to set the IsolationLevel as ReadUncommited (basically doing NOLOCK, as ...

I'm developing a web application using ASP.NET MVC and EF6 to access the database. One of the features of my web application allow the user to download a Excel file. The query to get the information ...