ASP.NET MVC EntityFramework多对多关系中间表怎么加字段,小白求指教
ASP.NET MVC EntityFramework多对多关系中间表如何加字段,小白求指教
ASP.NET MVC EntityFramework中现有一个多对多关系,想要实现在多对多的中间表上加字段sort排序字段,但是不知道怎么加,
2个实体为
对应的map为
对应的dbcontext是这个样子的
ASP.NET MVC EntityFramework中现有一个多对多关系,想要实现在多对多的中间表上加字段sort排序字段,但是不知道怎么加,
2个实体为
public class Column
{
//序号
public int ID { get; set; }
//栏目编号
public int Col_ID { get; set; }
//栏目名称
public int Col_Name { get; set; }
//父栏目编号
public int FatherCol { get; set; }
//层次
public int Lvl { get; set; }
//排序
public int SortBy { get; set; }
//状态
public int State { get; set; }
public virtual ICollection<FilterCategory> FilterCategorys { get; set; }
}
public class FilterCategory
{
//序号
public int ID { get; set; }
//筛选类别编号
public int Fc_ID { get; set; }
//筛选类别名称
public int Fc_Name { get; set; }
//状态
public int State { get; set; }
public virtual ICollection<Column> Columns { get; set; }
}
对应的map为
public class ColumnMap : EntityTypeConfiguration<Column>
{
public ColumnMap()
{
// Primary Key
this.HasKey(t => t.ID);
// Table & Column Mappings
this.ToTable("Columns");
}
}
public class FilterCategoryMap : EntityTypeConfiguration<FilterCategory>
{
public FilterCategoryMap()
{
// Primary Key
this.HasKey(t => t.ID);
// Table & Column Mappings
this.ToTable("FilterCategorys");
// Relationships
this.HasMany(t => t.Columns)
.WithMany(t => t.FilterCategorys)
.Map(m =>
{
m.ToTable("Columns_FilterCategorys");
m.MapLeftKey("Col_ID");
m.MapRightKey("Fc_ID");
});
}
}
对应的dbcontext是这个样子的
public class Context :DbContext
{
public DbSet<Column> Columns { get; set; }
public DbSet<FilterCategory> FilterCategorys { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//Add entity configurations in a structured way using 'TypeConfiguration’ classes
modelBuilder.Configurations.Add(new ColumnMap());
modelBuilder.Configurations.Add(new FilterCategoryMap());