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 }