Entity Framework 6 - Knowledge Base (KB)

Questions about Entity Framework Context Lifetime

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...

Dapper/EF - why is there a performance increase when variable is outside of using

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...