小编给大家分享一下ASP.NET使用EntityFrameworkCore CodeFrist 的方法,希望大家阅读完这篇文章后大所收获,下面让我们一起去探讨吧!
1,首先根据个人需要下载对应的微软官方.net core sdk和runtime
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 的方法有了一定的了解,想了解更多相关知识,欢迎关注亿速云行业资讯频道,感谢各位的阅读!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。