NET5CodeFist实体类生成数据库

第68节

• 首先建立实体类。

• 建立DbContext

public class AuthorityDbContext : DbContext{private ConfigOptions option &＃61; null;public AuthorityDbContext(IOptions<ConfigOptions> options){this.option &＃61; options.Value;}public AuthorityDbContext(){}protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder){string connectionString &＃61; "Server&＃61;.;Database&＃61;LiveBackgroundManagement;Trusted_Connection&＃61;True;";optionsBuilder.UseSqlServer(connectionString);//使用SqlServer的链接字符串 optionsBuilder.UseLazyLoadingProxies();}#region 后台 public DbSet<SysLog> SysLog { get; set; }public DbSet<SysMenu> SysMenu { get; set; }public DbSet<SysRole> SysRole { get; set; }public DbSet<SysRoleMenuMapping> SysRoleMenuMapping { get; set; }public DbSet<SysUser> SysUser { get; set; }public DbSet<SysUserMenuMapping> SysUserMenuMapping { get; set; }public DbSet<SysUserRoleMapping> SysUserRoleMapping { get; set; }#endregion#region 前台public DbSet<CSComment> CSComment { get; set; }public DbSet<CSRoom> CSRoom { get; set; }public DbSet<CSRoomType> CSRoomType { get; set; }public DbSet<CSScoreList> CSScoreList { get; set; }public DbSet<CSUser> CSUser { get; set; }public DbSet<CSUserApply> CSUserApply { get; set; }#endregionprotected override void OnModelCreating(ModelBuilder modelBuilder){}}

启动项目&＃xff0c;建库

• 通过控制台启动的时候&＃xff0c;创建数据库

class Program{static void Main(string[] args){try{#region 通过Api生成数据库-----CodeFirst;代码写好&＃xff0c;生成数据库&＃xff1b;using (AuthorityDbContext context &＃61; new AuthorityDbContext()){///生成数据库context.Database.EnsureDeleted();//判断是否有数据库&＃xff0c;如果有就删除context.Database.EnsureCreated();//新建立一个数据库}#endregion}catch (Exception ex){Console.WriteLine(ex.Message);}}}