1  public class WBIDbContext : DbContext 2     { 3         public DbSet<SysUserMdl> Users { get; set; } 4         public DbSet<SysUserGroupMdl> UserGroups { get; set; } 5         public DbSet<SysMenuModuleMdl> MenuModules { get; set; } 6         public DbSet<SysMenuItemMdl> MenuItems { get; set; } 7  8         public DbSet<VidCameraMdl> Cameras { get; set; } 9 10         public DbSet<DevDevtypeMdl> DevType { get; set; }//增加设备表的读取11 12        // public DbSet<VidDiskRecorderMdl> VideoHosts { get; set; }13 14         public WBIDbContext()15             : base("DefaultConnection")16         {17         }18     }

 1 public class WBIContextFactory 2     { 3         private const string KEY_DB_CONTEXT = "WBIDbContext"; 4  5         public static WBIDbContext GetCurrentContext() 6         { 7             WBIDbContext dbContext = 8                 CallContext.GetData(KEY_DB_CONTEXT) as WBIDbContext; 9 10             if (dbContext == null)11             {12                 dbContext = new WBIDbContext();13                 CallContext.SetData(KEY_DB_CONTEXT, dbContext);14             }15 16             return dbContext;17         }18     }

 1  //设备类型 2     [Table("t_dev_devtype")] 3     public class DevDevtypeMdl   4     { 5         [Key] 6         [Display(Name="设备编号")] 7         public string devid { get; set; } 8         [Display(Name = "设备编码")] 9         public string devtype { get; set; }10         [Display(Name = "名称描述")]11         public string devdesc { get; set; }12         [Display(Name = "排序")]13         public string devorder { get; set; }14         [Display(Name = "设备备注")]15         public string devmemo { get; set; }16     }