Change the name of bridge table generated by EF

under your dbcontext class override onmodelcreating method.

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity()
.HasMany(s => s. Product)
.WithMany(c => c.Customers)
.Map(cs =>
{
cs.MapLeftKey("CustomerId");
cs.MapRightKey("ProductId");
cs.ToTable("Order");
});
}

relation between customer and product will generate a bridge table named as CustomerProducts , we override this convention using ToTable() method , in my case i geve the table name "Order".

https://www.sharpencode.com/article/EntityFramework/how-to-establish-relationship-correctly/using-fluent-api

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
under your dbcontext class override onmodelcreating method.
protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
      modelBuilder.Entity()
                          .HasMany(s => s. Product)
                          .WithMany(c => c.Customers)
                          .Map(cs =>
                          {
                             cs.MapLeftKey("CustomerId");
                            cs.MapRightKey("ProductId");
                            cs.ToTable("Order");
                         });
           }
relation between customer and product will generate a bridge table named as CustomerProducts , we override this convention using ToTable() method , in my case i geve the table name "Order".
https://www.sharpencode.com/article/EntityFramework/how-to-establish-relationship-correctly/using-fluent-api