entity framework core mysql_.NetCore中EFCore for MySql整理(三)之Pomelo.EntityFrameworkCore.MySql...

public partial classRole

{public int RoleId { get; set; }public string Name { get; set; }public int SortValue { get; set; }

}public partial classMenu

{public int MenuId { get; set; }public string Name { get; set; }public string Title { get; set; }public string LinkUrl { get; set; }public string Icon { get; set; }

}public partial classRoleMenu

{public int Id { get; set; }public int RoleId { get; set; }public int MenuId { get; set; }

}public partial classRoleMenuContext : DbContext

{public virtual DbSet

{if (!optionsBuilder.IsConfigured)

{#warning To protect potentially sensitive information in your connection string, you should move it out of source code. See http://go.microsoft.com/fwlink/?LinkId=723263 for guidance on storing connection strings.optionsBuilder.UseMySql("Server=127.0.0.1;port=3306;Database=RoleMenu;uid=userone;pwd=123;Character Set=utf8;");

}

}protected override voidOnModelCreating(ModelBuilder modelBuilder)

{

modelBuilder.Entity

entity.Property(e=>e.MenuId)

.HasColumnName("MenuID")

.HasColumnType("int(11)");

entity.Property(e=> e.Icon).HasMaxLength(100);

entity.Property(e=> e.LinkUrl).HasMaxLength(200);

entity.Property(e=>e.Name)

.IsRequired()

.HasMaxLength(50);

entity.Property(e=>e.Title)

.IsRequired()

.HasMaxLength(100);

});

modelBuilder.Entity(entity =>{

entity.Property(e=>e.RoleId)

.HasColumnName("RoleID")

.HasColumnType("int(11)");

entity.Property(e=>e.Name)

.IsRequired()

.HasMaxLength(50);

entity.Property(e=> e.SortValue).HasColumnType("int(11)");

});

modelBuilder.Entity(entity =>{

entity.ToTable("Role_Menu");

entity.HasIndex(e=>e.MenuId)

.HasName("MenuID");

entity.HasIndex(e=>e.RoleId)

.HasName("RoleID");

entity.Property(e=>e.Id)

.HasColumnName("ID")

.HasColumnType("int(11)");

entity.Property(e=>e.MenuId)

.HasColumnName("MenuID")

.HasColumnType("int(11)");

entity.Property(e=>e.RoleId)

.HasColumnName("RoleID")

.HasColumnType("int(11)");

});

}

}