根据代码生成数据库(基于.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

结果如下图所示:

 

 

来查看一下数据库:

 

 

数据库创建完成;

 

  

posted @ 2021-11-20 21:11  艾特-天空之海  阅读(177)  评论(0编辑  收藏  举报