Multiple EF6 DbContext for one DbConfiguration in ASP.NET 5

Question

I'm trying to port my MVC 5 application to MVC 6. I'm using Devart dotConnect for MySql and Oracle. I have trouble configuring my application.

Right now I have the following entries:

<entityFramework>
    <providers>
        <provider invariantName="Devart.Data.MySql" type="Devart.Data.MySql.Entity.MySqlEntityProviderServices, Devart.Data.MySql.Entity" />
        <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
    </entityFramework>
    <system.data>
    <DbProviderFactories>
        <remove invariant="Devart.Data.MySql" />
        <add name="dotConnect for MySQL" invariant="Devart.Data.MySql" description="Devart dotConnect for MySQL" type="Devart.Data.MySql.MySqlProviderFactory, Devart.Data.MySql" />
    </DbProviderFactories>
</system.data>

My application have 3 DbContext classes (2x MySql, 1x Oracle) in separate assemblies, and I can only have 1 DbConfiguration class (Entity Framework 6 limitation).

If I set this configuration other contexts complain that they cannot see assembly with DbConfiguration class.

How do I get over that limitation?

Look at the recent question. It could be probably what you need. — Oleg
– Oleg, Commented Dec 21, 2015 at 17:45
@Oleg - I don't think EF6 and EF7 work the same way at this level — Pawel
– Pawel, Commented Dec 21, 2015 at 19:06
@Pawel: I interpret the question so, that one want to migrate from Entity Framework 6 to EF7 in the same way like one migrate from MVC 5 to MVC 6. One described the current configuration in EF6 and want to migrate to EF7. It's my interpretation of the question. EF7 don't have DbConfiguration, but one can define and use multiple DbContext classes, with connections to different databases. On the other side I don't know whether providers for MySql and Oracle are already available at least as beta. If one don't have anyone then the usage of ASP.NET 5 would be too early. — Oleg
– Oleg, Commented Dec 21, 2015 at 19:40
I want to stay with EF6 (because there are no providers for MySql and Oracle), but migrate to MVC6 — Shadow
– Shadow, Commented Dec 22, 2015 at 8:22

Dan Dohotaru · Accepted Answer · 2018-09-07 08:49:05Z

-2

I found myself in a similar situation the other day, and had to rely on web.config to enrich the configuration

<entityFramework codeConfigurationType="MyNamespace.MyDbConfiguration, MyAssembly">
...Your EF config...
</entityFramework>

Edit

The second option is to place DbConfigurationTypeAttribute on your context class

[DbConfigurationType(typeof(MyDbConfiguration))]
public class MyContextContext : DbContext
{
}

For more details check these resources

Ef6 docs: Code-Based Configuration Type (EF6 Onwards)

Ef6 docs: Moving DbConfiguration

edited Sep 7, 2018 at 8:49

answered Sep 6, 2018 at 11:30

Dan Dohotaru

3,1291 gold badge23 silver badges15 bronze badges

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

3 Comments

Dan Dohotaru Over a year ago

Of course it doesn't. I might have left some context out of view, but my reply is also related to migrating an existing web api from asp.net to asp.net core (keeping both of them alive for a while). They both rely on the very same ef6 implementation (hence being forced to target .net framework till swapping to entity framework core)

Shadow Over a year ago

So I do not understand how Your answer is relevant if config is not loaded. Your reply is totally out of context.

Shadow Over a year ago

Edit is relevant, however it is not good solution, because all DbContexts in application need reference to that class, so if You have decoupled plugins You have mess. Also if You have plugins with different db providers You have to reference all database drivers. Kind of works for simple cases, but cannot replace config file.

Collectives™ on Stack Overflow

Multiple EF6 DbContext for one DbConfiguration in ASP.NET 5

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related