根据代码生成数据库(基于.Net5)
一、引入命名空间
创建项目后,先引入命名空间,创建两个文件夹(Infrastructure和Models)
Startup的代码如下
public class Startup { public Startup(IConfiguration configuration) { Configuration = configuration; } public IConfiguration Configuration { get; } // This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddRazorPages(); services.AddSession(); services.AddDbContextPool( options => options.UseSqlServer("server=.; database=TestDB;Trusted_Connection=true")//Configuration.GetConnectionString()) ); } // This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Error"); } app.UseSession(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapRazorPages(); }); } }
二、创建类
创建Student类,代码如下
public class Student { public int Id { get; set; } public string Name { get; set; } public string Email { get; set; } }
创建AppDbContext类,代码如下
public class AppDbContext : DbContext { public AppDbContext(DbContextOptionsoptions) : base(options) { } public DbSet Student { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity ().HasData( new Student { Email = "41321@qq.com", Id = 1, Name = "Name" } ); ; } }
三、修改配置文件appsettings.json
增加节点:
"ConnectionStrings": {
"DBConnectiong": "server=.; database=TestDB;Trusted_Connection=true"
},
说明:server=.; database=TestDB;Trusted_Connection=true 是链接数据库的字符串;TestDB是数据库的名称;
四、进入控制台
输入命令:Add-Migration InitialCreate
再输入命令:Update-Database
结果如下图所示:
来查看一下数据库:
数据库创建完成;