ASP.NET Core使用EntityFrameworkCore CodeFrist

时间:2022-06-12 14:50:41

1,安装环境:

如果是VS2015,确保已经升级至 update3或以上

.net core sdk (https://www.microsoft.com/net/download/core)

vs2015 tools

2,创建一个asp.net Core的项目

ASP.NET Core使用EntityFrameworkCore CodeFrist

3,创建实体Entity,用户和角色

    public class User
{
public int Id { get; set; }
/// <summary>
/// 角色Id
/// </summary>
public int RoleId { get; set; }
public virtual Role Role { get; set; }
/// <summary>
/// 状态
/// </summary>
public int Status { get; set; }
/// <summary>
/// 登陆名
/// </summary>
public string Login { get; set; }
/// <summary>
/// 登陆密码
/// </summary>
public string Pwd { get; set; }
}
    public class Role
{
public int Id { get; set; }
/// <summary>
/// 角色名
/// </summary>
public string Name { get; set; }
/// <summary>
/// 一个角色的多个用户
/// </summary>
public virtual ICollection<User> Users { get; set; }
}

4,创建DbContext

    public class EFDbContext: DbContext
{
public EFDbContext(DbContextOptions<EFDbContext> options) : base(options)
{ }
public DbSet<Role> Roles { get; set; }
public DbSet<User> Users { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
Role(modelBuilder);
User(modelBuilder);
} private void User(ModelBuilder modelBuilder)
{
var userBuilder = modelBuilder.Entity<User>().ToTable("User");
// Properties
userBuilder.Property(t => t.Id).ValueGeneratedOnAdd();
userBuilder.Property(t => t.RoleId).IsRequired();
userBuilder.Property(t => t.Status).IsRequired();
userBuilder.Property(t => t.Login).IsRequired().HasMaxLength(30);
userBuilder.Property(t => t.Pwd).IsRequired().HasMaxLength(60);
// Primary Key
userBuilder.HasKey(t => t.Id);
// Index
userBuilder.HasIndex(t => t.Login);
// Relationships
userBuilder.HasOne(t => t.Role).WithMany(t => t.Users).HasForeignKey(t => t.RoleId);
} private void Role(ModelBuilder modelBuilder)
{
var roleBuilder = modelBuilder.Entity<Role>().ToTable("Role");
// Properties
roleBuilder.Property(t => t.Id).ValueGeneratedOnAdd();
roleBuilder.Property(t => t.Name).IsRequired().HasMaxLength(30);
// Primary Key
roleBuilder.HasKey(t => t.Id);
}
}

5,创建DbInitializer,用于创建初始数据

    public class DbInitializer
{
public async static Task InitData(EFDbContext context)
{
if (context.Database != null && context.Database.EnsureCreated())
{
//角色配置
context.Roles.AddRange(new Role[]
{
new Role { Name="超级管理员" },
new Role { Name="管理员" }
});
//默认用户
context.Users.AddRange(new User[]
{
new User { RoleId=1, Login="administrator", Pwd="111111" },
new User { RoleId=2, Login="admin", Pwd="111111" }
}); await context.SaveChangesAsync();
}
}

6,修改Startup类方法

在ConfigureServices添加如下代码

// DbContext
services.AddDbContext<EFDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

在Configure方法内添加

        public async void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug(); app.UseMvc(); await DbInitializer.InitData(app.ApplicationServices.GetService<EFDbContext>());
}

7,修改appsettings.json

{
"ConnectionStrings": {
"DefaultConnection": "Data Source=.;Initial Catalog=LniceCore;Integrated Security=SSPI;"
},
"Logging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Debug",
"System": "Information",
"Microsoft": "Information"
}
}
}

8,运行程序,查看结果

ASP.NET Core使用EntityFrameworkCore CodeFristASP.NET Core使用EntityFrameworkCore CodeFrist

ASP.NET Core使用EntityFrameworkCore CodeFristASP.NET Core使用EntityFrameworkCore CodeFrist