public static void Configure(SqlServerContextBase context, DbModelBuilder modelBuilder)
{
#region CalendarEvent
modelBuilder.Entity <CalendarEvent>()
.ToTable(CodeGenerationHelper.GetTableName <CalendarEvent>());
modelBuilder.Entity <CalendarEvent>()
.HasKey(x => x.Id);
modelBuilder.Entity <CalendarEvent>()
.HasRequired(x => x.Recurrence)
.WithMany();
modelBuilder.Entity <CalendarEvent>()
.HasRequired(x => x.Status)
.WithMany();
#endregion
#region CalendarEventRecurrence
modelBuilder.Entity <CalendarEventRecurrence>()
.ToTable(CodeGenerationHelper.GetTableName <CalendarEventRecurrence>());
modelBuilder.Entity <CalendarEventRecurrence>()
.HasKey(x => x.Id);
#endregion
#region CalendarEventStatus
modelBuilder.Entity <CalendarEventStatus>()
.ToTable(CodeGenerationHelper.GetTableName <CalendarEventStatus>());
modelBuilder.Entity <CalendarEventStatus>()
.HasKey(x => x.Id);
#endregion
}
public static void Configure(SqlServerContextBase context, DbModelBuilder modelBuilder)
{
#region NewsItem
modelBuilder.Entity <NewsItem>()
.ToTable(CodeGenerationHelper.GetTableName <NewsItem>());
modelBuilder.Entity <NewsItem>()
.HasKey(x => x.Id);
#endregion
}
public static void Configure(SqlServerContextBase context, DbModelBuilder modelBuilder)
{
#region Permission
modelBuilder.Entity <Permission>()
.ToTable(CodeGenerationHelper.GetTableName <Permission>());
modelBuilder.Entity <Permission>()
.HasKey(x => x.Id);
modelBuilder.Entity <Permission>()
.HasRequired(x => x.Role)
.WithMany(x => x.PermissionList);
#endregion
#region Role
modelBuilder.Entity <Role>()
.ToTable(CodeGenerationHelper.GetTableName <Role>());
modelBuilder.Entity <Role>()
.HasKey(x => x.Id);
modelBuilder.Entity <Role>()
.HasMany(x => x.PermissionList)
.WithRequired(x => x.Role);
modelBuilder.Entity <Role>()
.HasMany(x => x.UserRoleList)
.WithRequired(x => x.Role);
#endregion
#region User
modelBuilder.Entity <User>()
.ToTable(CodeGenerationHelper.GetTableName <User>());
modelBuilder.Entity <User>()
.HasKey(x => x.Id);
modelBuilder.Entity <User>()
.HasMany(x => x.UserRoleList)
.WithRequired(x => x.User);
#endregion
#region UserRole
modelBuilder.Entity <UserRole>()
.ToTable(CodeGenerationHelper.GetTableName <UserRole>());
modelBuilder.Entity <UserRole>()
.HasKey(x => x.Id);
modelBuilder.Entity <UserRole>()
.HasRequired(x => x.Role)
.WithMany(x => x.UserRoleList);
modelBuilder.Entity <UserRole>()
.HasRequired(x => x.User)
.WithMany(x => x.UserRoleList);
#endregion
}
public static void Configure(SqlServerContextBase context, DbModelBuilder modelBuilder)
{
#region MetadataEntity
modelBuilder.Entity <MetadataEntity>()
.ToTable(CodeGenerationHelper.GetTableName <MetadataEntity>());
modelBuilder.Entity <MetadataEntity>()
.HasKey(x => x.Id);
modelBuilder.Entity <MetadataEntity>()
.HasMany(x => x.MetadataFieldList)
.WithRequired(x => x.MetadataEntity);
modelBuilder.Entity <MetadataEntity>()
.HasMany(x => x.MetadataNavigationPropertyList)
.WithRequired(x => x.MetadataEntity);
#endregion
#region MetadataEntity-MetadataEntity-MetadataUsage
modelBuilder.Entity <MetadataEntity>()
.HasMany(x => x.UsingEntityList)
.WithMany(x => x.UsedEntityList)
.Map(m => m.ToTable("MetadataUsage").MapLeftKey("UsedEntity_Id").MapRightKey("UsingEntity_Id"));
#endregion
#region MetadataField
modelBuilder.Entity <MetadataField>()
.ToTable(CodeGenerationHelper.GetTableName <MetadataField>());
modelBuilder.Entity <MetadataField>()
.HasKey(x => x.Id);
modelBuilder.Entity <MetadataField>()
.HasRequired(x => x.MetadataEntity)
.WithMany(x => x.MetadataFieldList);
#endregion
#region MetadataNavigationProperty
modelBuilder.Entity <MetadataNavigationProperty>()
.ToTable(CodeGenerationHelper.GetTableName <MetadataNavigationProperty>());
modelBuilder.Entity <MetadataNavigationProperty>()
.HasKey(x => x.Id);
modelBuilder.Entity <MetadataNavigationProperty>()
.HasRequired(x => x.MetadataEntity)
.WithMany(x => x.MetadataNavigationPropertyList);
#endregion
}
public static void AddForeignKeyIndexes(IList <NonUniqueIndex> indexes, SqlServerContextBase context)
{
#region CalendarEvent
//indexes.Add(context.GetNonUniqueIndexFor<CalendarEvent>("Recurrence_Id"));
//indexes.Add(context.GetNonUniqueIndexFor<CalendarEvent>("Status_Id"));
#endregion
#region CalendarEventRecurrence
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
#region CalendarEventStatus
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
}
public static void AddForeignKeyIndexes(IList <NonUniqueIndex> indexes, SqlServerContextBase context)
{
#region MetadataEntity
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
#region MetadataField
//indexes.Add(context.GetNonUniqueIndexFor<MetadataField>("MetadataEntity_Id"));
#endregion
#region MetadataNavigationProperty
//indexes.Add(context.GetNonUniqueIndexFor<MetadataNavigationProperty>("MetadataEntity_Id"));
#endregion
}
public static void AddForeignKeyIndexes(IList <NonUniqueIndex> indexes, SqlServerContextBase context)
{
#region Permission
//indexes.Add(context.GetNonUniqueIndexFor<Permission>("Role_Id"));
#endregion
#region Role
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
#region User
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
#region UserRole
//indexes.Add(context.GetNonUniqueIndexFor<UserRole>("Role_Id"));
//indexes.Add(context.GetNonUniqueIndexFor<UserRole>("User_Id"));
#endregion
}
public static void AddUniqueConstraints(IList <UniqueIndex> uniqueConstraints, SqlServerContextBase context)
{
#region Permission
uniqueConstraints.Add(context.GetUniqueIndexFor <Permission>("ItemName", "Role_Id"));
#endregion
#region Role
uniqueConstraints.Add(context.GetUniqueIndexFor <Role>("Name"));
#endregion
#region User
uniqueConstraints.Add(context.GetUniqueIndexFor <User>("UserName"));
#endregion
#region UserRole
uniqueConstraints.Add(context.GetUniqueIndexFor <UserRole>("Role_Id", "User_Id"));
#endregion
}
public static void AddUniqueConstraints(IList <UniqueIndex> uniqueConstraints, SqlServerContextBase context)
{
#region CalendarEvent
//None(inheritance TPH or no discriminant)
#endregion
#region CalendarEventRecurrence
uniqueConstraints.Add(context.GetUniqueIndexFor <CalendarEventRecurrence>("Code"));
#endregion
#region CalendarEventStatus
uniqueConstraints.Add(context.GetUniqueIndexFor <CalendarEventStatus>("Code"));
#endregion
}
public static void AddUniqueConstraints(IList <UniqueIndex> uniqueConstraints, SqlServerContextBase context)
{
}
public static void AddForeignKeyIndexes(IList <NonUniqueIndex> indexes, SqlServerContextBase context)
{
}
public static void Configure(SqlServerContextBase context, DbModelBuilder modelBuilder)
{
}
public static void AddUniqueConstraints(IList <UniqueIndex> uniqueConstraints, SqlServerContextBase context)
{
#region MetadataEntity
//None(inheritance TPH or no discriminant)
#endregion
#region MetadataField
//None(inheritance TPH or no discriminant)
#endregion
#region MetadataNavigationProperty
//None(inheritance TPH or no discriminant)
#endregion
}
public static void AddUniqueConstraints(IList <UniqueIndex> uniqueConstraints, SqlServerContextBase context)
{
#region NewsItem
//None(inheritance TPH or no discriminant)
#endregion
}
public static void AddForeignKeyIndexes(IList <NonUniqueIndex> indexes, SqlServerContextBase context)
{
#region NewsItem
//None(inheritance TPH or no *..{1,0..1} association or no index)
#endregion
}
