实体框架6.x mysql,在实体框架中使用MySQL和MSSQL 6

I'm developing a webservice.

Behind this service are two methods:

One to get entities from a MySQL Connection and the other to get entities from a MSSQL Server Connection.

I have two connection strings.

I would like to have two contexts, they are completely separated.

But i'm not able to manage this.

Any ideas?

解决方案

The solution was simple in the end.

Be sure to install MySql Connector/Net on all target systems!

I missed this on my target platform.

web.config / app.config:

MsSqlServerContext.cs

public partial class MsSqlServerContext : DbContext

{

public MsSqlServerContext()

: base("name=MsSqlServerContext")

{

Database.SetInitializer(null);

}

// Add DbSets here

public DbSet SomeName1 { get; set; }

public DbSet SomeName2 { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)

{

// Add Mappings here

modelBuilder.Configurations.Add(new ClassName1Map());

modelBuilder.Configurations.Add(new ClassName2Map());

}

}

MySqlServerContext

public partial class MySqlServerContext : DbContext

{

public MySqlServerContext()

: base("name=MySqlServerContext")

{

Database.SetInitializer(null);

}

public DbSet SomeName3 { get; set; }

public DbSet SomeName4 { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)

{

modelBuilder.Configurations.Add(new ClassName3Map());

modelBuilder.Configurations.Add(new ClassName4Map());

}

}