Entity Framework 6 - Knowledge Base (KB)

Entity Framework Context Lifetime Questions

I have some questions about the desired lifetime of an Entity Framework context in an ASP.NET MVC application. Isn't it best to keep the context alive for the shortest time possible?...Consider the following controller action:...public ActionResult Index(...

Entity Framework, DBContext and using() + async?

There is a thing that's been bugging me for a long time about Entity Framework....Last year I wrote a big application for a client using EF. And during the development everything worked great....We shipped the system in august. But after some weeks I star...

Why is there a performance boost when the variable is not being used in Dapper/EF?

I ran both the below queries using the same params and stored proc. Example A takes over a minute, whereas example B takes under 20 seconds. If I call this same proc using EF, then I'm down to about 10 seconds (there is just over 50000 records returned). ...

How do I make DbContext in using statement work with unit tests?

The situation I have is this:...I am working on an ASP.NET MVC project that does not implement the repository pattern...All ...DbContext... calls are made from the controller layer...DbContext... is wrapped in a using statement and instantiated as necessa...