entityframwork

entityframwork映射部分:

  public class NorthwindContext : DbContext
{ public DbSet<CATEGORIES> Categories { get; set; }
public DbSet<CUSTOMERS> Customers { get; set; }
public DbSet<EMPLOYEES> Employees { get; set; }
public DbSet<PRODUCTS> Products { get; set; }
public DbSet<ORDERS> Orders { get; set; }
public DbSet<SUPPLIERS> Suppliers { get; set; }
public DbSet<SHIPPERS> Shippers { get; set; }
public DbSet<ORDER_DETAILS> Order_Details { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder)
{ modelBuilder.Entity<CATEGORIES>().ToTable("CATEGORIES", "TEMP");
modelBuilder.Entity<CUSTOMERS>().ToTable("CUSTOMERS", "TEMP");
modelBuilder.Entity<EMPLOYEES>().ToTable("EMPLOYEES", "TEMP");
modelBuilder.Entity<PRODUCTS>().ToTable("PRODUCTS", "TEMP");
modelBuilder.Entity<ORDERS>().ToTable("ORDERS", "TEMP");
modelBuilder.Entity<SUPPLIERS>().ToTable("SUPPLIERS", "TEMP");
modelBuilder.Entity<SHIPPERS>().ToTable("SHIPPERS", "TEMP");
modelBuilder.Entity<ORDER_DETAILS>().ToTable("ORDER_DETAILS", "TEMP"); modelBuilder.Entity<SUPPLIERS>().HasMany(b => b.Products1).WithRequired(a => a.SUPPLIERS1);
modelBuilder.Entity<EMPLOYEES>().HasMany(b => b.Employees1).WithRequired(a => a.Employees2);
modelBuilder.Entity<CUSTOMERS>().HasMany(b => b.Orders).WithRequired(a => a.Customers);
modelBuilder.Entity<EMPLOYEES>().HasMany(b => b.Orders).WithRequired(a => a.Employees);
modelBuilder.Entity<CATEGORIES>().HasMany(b => b.Products).WithRequired(a => a.CATEGORIES);
modelBuilder.Conventions.Remove<System.Data.Entity.ModelConfiguration.Conventions.ColumnTypeCasingConvention>(); base.OnModelCreating(modelBuilder);
}
}

  

上一篇:Elasticsearch--数据索引


下一篇:Sql Server系列:游标