entityframwork_.NET_编程开发_程序员俱乐部

entityframwork映射部分：

class="brush:csharp;gutter:false;">  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);
        }
    }