Entity Framework 6 - Knowledge Base (KB)

SqlException from Entity Framework - New transaction is not allowed because there are other threads running in the session

I am currently getting this error:...System.Data.SqlClient.SqlException: New transaction is not allowed because there are other threads running in the session....while running this code:...public class ProductManager : IProductManager { #region Declar...

One DbContext per web request... why?

I have been reading a lot of articles explaining how to set up Entity Framework's ...DbContext... so that only one is created and used per HTTP web request using various DI frameworks....Why is this a good idea in the first place? What advantages do you g...

Using Entity Framework with Castle Windsor

I use the Entity Framework database-first approach to generate a DbContext / POCO model for an MVC application. I want to avoid having dependencies on DbContext in my controllers to enable me to switch to another persistence provider as I need to (for exa...

Injecting DbContext into Repository class library

The projects in my solution are set up like this:...App.Data...App.Models...App.Web...In App.Data, I'm using Entity Framework to access my data with a bunch of Repositories to abstract interaction with it. For obvious reasons, I would like my App.Web to r...

Entity Framework using Repository Pattern, Unit of Work and Unity

Using a combination provided from ...this example... and ...this implementation... I am trying to create a solution that decouples the ...UnitOfWork... class from the individual repositories, as they violate the Open-Closed Principle, since every time you...

Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form

I'm trying to implement IoC in my windows form application. My choice fell on Simple Injector, because it's fast and lightweight. I also implement unit of work and repository pattern in my apps. Here is the structure:...DbContext...:...public class Member...

Asp.net core best practice example

I was searching for an example that implement all the new principles in .net web development, i found a good one but it was for mvc4...visit ...http://www.c-sharpcorner.com/UploadFile/3d39b4/crud-operations-using-the-generic-repository-pattern-and-dep/...