CODEWITHSUNDEEP
c#entity-frameworkentity-framework-4
mironych
mironych

Reputation: 2978

DbContext Table mappings

I have tried to implement this scenario. I have created Code First model, then generated database sql from model, and have created manual migrations via MigSharp. After that i have added code to OnModelCreating to update mappings.

protected  void OnModelCreating(DbModelBuilder modelBuilder)
{
  modelBuilder.Entity<Product>().ToTable("dfg_Product");
  modelBuilder.Entity<Customer>().ToTable("dfg_Customer");
}

Problem is that DbContext still trying to get data from default mappings "dbo.Product | dbo.Customer" and I need to change mappings to "dbo.dfg_Product | dbo.dfg_Customer". I have tried to debug but code in OnModelCreating does not invoked.

Please help, what I am doing wrong?

EDIT: Added connection string

<add name="DataModelContainer" connectionString="metadata=res://*/DataModel.csdl|res://*/DataModel.ssdl|res://*/‌​DataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=localhost\SQLEXPRESS;initial catalog=TestDB;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Problem was solved by changing connection string to:

<add name="DataModelContainer" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=TestDB;integrated security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />

Upvotes: 3

Views: 9150

Answers (1)

Matija Grcic
Matija Grcic

Reputation: 13381

If you executed your application before and your model remains the same, the database is already there and OnModelCreating() will not get called.

You can use Database.SetInitializer()

static void Main(string[] args)
{
     Database.SetInitializer(
            new DropCreateDatabaseIfModelChanges<YourContext>());
     //or
     Database.SetInitializer(
            new DropCreateDatabaseAlways<YourContext>());
     //your code
}

Also i noticed you're using FluentAPI and i want to point you can also use attributes for mappings:

[Table("dfg_Product")]
public class Product

Hope it helps.

EDIT:

You are using 

modelBuilder.Entity<Product>().ToTable("dfg_Product");

and this is why it created dbo.Product. Use 

modelBuilder.Entity<Product>().MapSingleType().ToTable("dfg_Product");

and please use DropCreateDatabaseAlways() so you'll get a new database with correct mappings.

EDIT 2

You don't need metadata information in the connection string when developing a Code First application so your connection string should look like this: 

<add name="DataModelContainer" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=TestDB;integrated security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />

Upvotes: 3

Related Questions