2,建立一个asp.net Core的项目
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运用EntityFrameworkCore CodeFrist 的细致内容,更多请关注ki4网别的相干文章!