根据代码生成数据库(基于.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<AppDbContext>(
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(DbContextOptions<AppDbContext> options) : base(options)
{
}
public DbSet<Student> Student { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Student>().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
结果如下图所示:

来查看一下数据库:

数据库创建完成;

浙公网安备 33010602011771号