How to Use Entity Framework 6.x in Asp.Net 5 (MVC 6)

Question

I'm testing out the new Asp.Net 5, using VS 2015 CTP-6. Because of the lack of features in Entity Framework 7, I would prefer using EF6 for now.

I've tried removing EF7 and then applying EF6 in PM, like this:

Uninstall-Package EntityFramework
Install-Package EntityFramework -version 6.1.3

No errors returned, and the project.json file seems updated accordingly. Although, there are no DbContext available.

Is this at all possible? If yes, how should I proceed from here? Do I need web.config for EF6 compatibility?

Tom · Accepted Answer · 2015-04-10 23:32:35Z

17

Yes, this works fine.

You need to manually set the connection string when creating the context since it can't get it from the web.config

so you can do this

public class MyContext : DbContext {
    public MyContext(string connectionString) : base(connectionString) {
    }
}

var context = new MyContext("myConnectionString");

if you want to get the connection string from the config.json, then try this

IConfiguration configuration = new Configuration().AddJsonFile("config.json");
var connectionString = configuration["Data:DefaultConnection:ConnectionString"]);

and if you want to inject the context into the DI Container, then I added a factory like this

public static class MyContextFactory
{
    public static MyContext GetContext() {
        IConfiguration configuration = new Configuration().AddJsonFile("config.json");
        return new MyContext(configuration["Data:DefaultConnection:ConnectionString"]);
    }

}

and then added this in startup.cs

services.AddTransient<MyContext>((a) => MyContextFactory.GetContext());

answered Apr 10, 2015 at 23:32

Tom

8367 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Yashvit Over a year ago

Do we need to still include System.Data into the project? Would that also go into the dependencies ?

Gareth Suarez Over a year ago

you won't need to set the dependencies, but since EF 6 is not supported by .net core, you will need to make sure your framework is referencing "dnx451" instead of "dotnet" in the project.son.

afnpires Over a year ago

As answered by kenstone, ConfigurationBuilder should be used in the RC, instead of Configuration. stackoverflow.com/a/33834167/3805983

T.Coutlakis Over a year ago

Looks nice, but how do you use MyContext?

Tom Over a year ago

Just add it to the constructor of the controller you need it in: public IActionResult MyController(MyContext context)

pg0xC · Accepted Answer · 2015-11-09 16:41:21Z

6

Depending on database used it may not be as easy as answered. If you are using MsSql then no configuration is needed and the accepted answer is perfectly fine. But using LocalDB may need some configuration.

For example MySql needs to register provider

[DbConfigurationType(typeof(CodeConfig))] // point to the class that inherit from DbConfiguration
public class ApplicationDbContext : DbContext
{
    [...]
}

public class CodeConfig : DbConfiguration
{
    public CodeConfig()
    {
        SetDefaultConnectionFactory(new MySql.Data.Entity.MySqlConnectionFactory());
        SetProviderServices("MySql.Data.MySqlClient",
                    new MySql.Data.MySqlClient.MySqlProviderServices());
    }
}

PostgreSql needs to register provider into entityFramework AND system.data section. This may be done by using System.Data.Entity.DbConfiguration.Loaded event. Same goes with Oracle.

Check this blog post that explains it in details: http://bleedingnedge.com/2015/11/01/entity-framework-6-with-asp-net-5/

edited Nov 9, 2015 at 16:41

answered Nov 9, 2015 at 14:14

pg0xC

1,26610 silver badges20 bronze badges

1 Comment

Andrey Borisko Over a year ago

I had a "Unable to determine the provider name for provider factory of type 'MySql.Data.MySqlClient.MySqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config." exception with MySQL. To make it work I added more settings in DbConfiguration class:

SetProviderFactory("MySql.Data.MySqlClient", new MySql.Data.MySqlClient.MySqlClientFactory());             SetProviderFactoryResolver(new MySql.Data.Entity.MySqlProviderFactoryResolver());

rfcdejong · Accepted Answer · 2016-02-04 17:34:43Z

5

Can you not just do this in the startup.cs file? Save creating a factory

// new context on each request
services.AddScoped<IMyContext, MyContext>((s) =>
{
    return new MyContext(Configuration["Data:MyConnection:ConnectionString"]);
});

edited Feb 4, 2016 at 17:34

rfcdejong

2,3201 gold badge26 silver badges53 bronze badges

answered Oct 12, 2015 at 11:25

Gillardo

9,85818 gold badges83 silver badges152 bronze badges

1 Comment

rfcdejong Over a year ago

or even in 1 line: services.AddScoped<IMyContext, MyContext>(s => new MyContext(Configuration["Data:MyConnection:ConnectionString"]));

kenstone · Accepted Answer · 2015-11-20 19:01:48Z

3

With the RC version, this becomes:

        var builder = new ConfigurationBuilder()
            .AddJsonFile("appsettings.json")
            .AddEnvironmentVariables();
        var Configuration = builder.Build();
        var connectionString = Configuration["Data:DefaultConnection:ConnectionString"];

answered Nov 20, 2015 at 19:01

kenstone

5167 silver badges14 bronze badges

Comments

sosha · Accepted Answer · 2016-08-13 07:26:00Z

‌Before you start, make sure that you compile against full .NET Framework in your project.json as Entity Framework 6 does not support .NET Core. If you need cross platform features you will need to upgrade to Entity Framework Core.

In your project.json file specify a single target for the full .NET Framework:

"frameworks": {
    "net46": {}
}

and then Setup connection strings and dependency injection

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(string nameOrConnectionString) : base(nameOrConnectionString)
    {
    }
}

In the Startup class within ConfigureServices add factory method of your context with it’s connection string. Context should be resolved once per scope to ensure performance and ensure reliable operation of Entity Framework.

public void ConfigureServices(IServiceCollection services)
{
    services.AddScoped((_) => new ApplicationDbContext(Configuration["Data:DefaultConnection:ConnectionString"]));

    // Configure remaining services
}

ntity Framework 6 allows configuration to be specified in xml (in web.config or app.config) or through code. As of ASP.NET Core, all configuration is code-based.

Code-based configuration is achieved by creating a subclass of System.Data.Entity.Config.DbConfiguration and applying System.Data.Entity.DbConfigurationTypeAttribute to your DbContext subclass.

Our config file typically looked like this:

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
        <parameters>
            <parameter value="mssqllocaldb" />
        </parameters>
    </defaultConnectionFactory>
    <providers>
        <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
</entityFramework>

The defaultConnectionFactory element sets the factory for connections. If this attribute is not set then the default value is SqlConnectionProvider. If, on the other hand, value is provided, the given class will be used to create DbConnection with its CreateConnection method. If the given factory has no default constructor then you must add parameters that are used to construct the object

[DbConfigurationType(typeof(CodeConfig))] // point to the class that inherit from DbConfiguration
public class ApplicationDbContext : DbContext
{
    [...]
}

public class CodeConfig : DbConfiguration
{
    public CodeConfig()
    {
        SetProviderServices("System.Data.SqlClient",
            System.Data.Entity.SqlServer.SqlProviderServices.Instance);
    }
}

This article will show you how to use Entity Framework 6 inside an ASP.NET Core application. https://docs.asp.net/en/latest/data/entity-framework-6.html

Collectives™ on Stack Overflow

How to Use Entity Framework 6.x in Asp.Net 5 (MVC 6)

5 Answers 5

5 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related