entityframwork
2013-08-08 10:21 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); } } |
STUDTY HARD FOR .NET
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步