8,497
社区成员
发帖
与我相关
我的任务
分享
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; }
}
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");
});
}
}
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());
}
}
public class Column_FilterCategory
{
//public int ID { get; set; }
//栏目编号
public int Col_ID { get; set; }
//筛选类别编号
public int Fc_ID { get; set; }
//排序
public int Sort { get; set; }
}