代码改变世界

entityframwork

  zhishuru  阅读(432)  评论(1编辑  收藏  举报

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);
      }
  }

  

复制代码
努力加载评论中...
点击右上角即可分享
微信分享提示