An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code, C#

Question

Im trying to work with databases and Entity-framework.

Here Is my Database:

I have the following file that creates an context:

namespace SportsStore.domain.Concrete
{
    //Associate the model with the database
    //This class then automatically defines a property for each table in the database that I want to work with. 
    public class EFDbContext : DbContext { 


        public DbSet Products { get; set; }

        /*protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove();
        }*/
    }
}

Here IS my file that Initialize the context-class:

namespace SportsStore.domain.Concrete
{
    public class EFProductRepository : IProductRepository
    {
        private EFDbContext context = new EFDbContext();

        public IEnumerable Products
        {
            get { return context.Products.ToList(); } 
        }
    }
}

When I run my application, I get the following error:

An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: Failed to set database initializer of type 'SportsStore.domain.Concrete, EFProductRepository' for DbContext type 'SportsStore.domain.Concrete, EFDbContext' specified in the application configuration. See inner exception for details.

Here Is the details message of the inner exception:

Can not load file or assembly EFDbContext or one of its dependencies. The system can not find the file EFDbContext

Here Is my App.config:

Here is my Web.Config:

How does it know which database to use?

I'm new to Entity framework and databases in .NET.

Martin Liversage · Accepted Answer

In your Web.config file you have the following configuration:

Here you specify that the assembly EFDbContext contains a context type SportsStore.domain.Concrete that should be initialized by initializer type SportsStore.domain.Concrete in assembly EFProductRepository.

Some of these names looks rather unorthodox. Combined with the underlying error that The system can not find the file EFDbContext my guess is that you need to go through this configuration and fix it.

Do you have one or two assemblies? If only one then specify the correct name in the configuration.
Are the context and the initializer specified by the correct type? If not correct the type names.
Do you even have an initializer? If not remove the configuration completely from Web.config. EFProductRepository is certainly not an initializer.

You specify a type in a configuration file like this:

[Fully qualified name of type including namespace], [Name of assembly without .DLL]

So to specify you context assuming the assembly name is EFDbContext you write this:

SportsStore.domain.Concrete.EFDbContext, EFDbContext

The assembly name is probably wrong based on the error that you get but only you know the correct name.

An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code, C#

Answers (2)

Related Questions

An exception of type &#39;System.InvalidOperationException&#39; occurred in EntityFramework.dll but was not handled in user code, C#

Answers (2)

Related Questions

An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code, C#