根据代码生成数据库(基于.Net5)

一、引入命名空间

创建项目后,先引入命名空间,创建两个文件夹(Infrastructure和Models)

 

 

Startup的代码如下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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类,代码如下

1
2
3
4
5
6
public class Student
   {
       public int Id { get; set; }
       public string Name { get; set; }
       public string Email { get; set; }
   }

  

创建AppDbContext类,代码如下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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

结果如下图所示:

 

 

来查看一下数据库:

 

 

数据库创建完成;

 

  

posted @   二维一加零  阅读(191)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
点击右上角即可分享
微信分享提示