protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <DemoEntity>().ToTable("Demo")
.HasKey(e => e.Id)
.Property(e => e.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove <System.Data.Entity.ModelConfiguration.Conventions.PluralizingTableNameConvention>();
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Site>().ToTable("Site");
modelBuilder.Entity <WifiUser>().ToTable("WifiUser");
modelBuilder.Entity <WifiUserLoginCredential>().ToTable("WifiUserLoginCredential");
modelBuilder.Entity <UsersAddress>().ToTable("UsersAddress");
modelBuilder.Entity <RtlsConfiguration>().ToTable("RtlsConfiguration");
modelBuilder.Entity <RtlsArea>().ToTable("RtlsArea").HasKey(m => m.Id);
modelBuilder.Entity <SiteFloor>().ToTable("SiteFloor");
modelBuilder.Entity <Device>().ToTable("Device");
modelBuilder.Entity <DeviceAssociateSite>().ToTable("DeviceAssociateSite");
modelBuilder.Entity <LocationData>().ToTable("LocationData");
modelBuilder.Entity <AppLog>().ToTable("AppLog");
modelBuilder.Entity <TrackMacNotification>().ToTable("TrackMacNotification");
modelBuilder.Entity <TrackMember>().ToTable("TrackMember");
modelBuilder.Entity <OmniDeviceMapping>().ToTable("OmniDeviceMapping");
modelBuilder.Entity <RtlsNotificationData>().ToTable("RtlsNotificationData");
modelBuilder.Entity <NetWorkOfSite>().ToTable("NetWorkOfSite");
modelBuilder.Entity <Site>()
.HasOptional(f => f.RtlsConfiguration)
.WithRequired(s => s.Site);
modelBuilder.Entity <Device>().HasOptional(g => g.OmniDeviceMapping).WithRequired(h => h.Device);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Configurations.Add(new A.Core.PermissionModule.Services.Mapping.RoleMap());
modelBuilder.Configurations.Add(new A.Core.PermissionModule.Services.Mapping.PermissionMap());
modelBuilder.Configurations.Add(new A.Core.PermissionModule.Services.Mapping.RolePermissionMap());
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <ApplicationUser>().Property(x => x.Balance).HasPrecision(18, 8);
modelBuilder.Properties <decimal>().Configure(x => x.HasPrecision(18, 8));
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <IdentityRole>().ToTable(BCM.Common.Constants.TablePrefix + "Roles");
modelBuilder.Entity <IdentityUserClaim>().ToTable(BCM.Common.Constants.TablePrefix + "UserClaims");
modelBuilder.Entity <IdentityUserLogin>().ToTable(BCM.Common.Constants.TablePrefix + "UserLogins");
modelBuilder.Entity <IdentityUserRole>().ToTable(BCM.Common.Constants.TablePrefix + "UserRoles");
modelBuilder.Entity <IdentityUser>().ToTable(BCM.Common.Constants.TablePrefix + "Users");
modelBuilder.Entity <ApplicationUser>().ToTable(BCM.Common.Constants.TablePrefix + "Users");
modelBuilder.Entity <Book>()
.HasMany(a => a.Authors)
.WithMany(a => a.Books)
.Map(m =>
{
m.ToTable(BCM.Common.Constants.TablePrefix + "BookAuthor");
m.MapLeftKey("BookId");
m.MapRightKey("AuthorId");
});
modelBuilder.Entity <Book>()
.HasMany(c => c.Categories)
.WithMany(c => c.Books)
.Map(m =>
{
m.ToTable(BCM.Common.Constants.TablePrefix + "BookCategory");
m.MapLeftKey("BookId");
m.MapRightKey("CategoryId");
});
}
/// <summary>
/// متد آن مدل کریتینگ برای اعمال کانفیگوریشن در کلاس ها
/// </summary>
/// <param name="modelBuilder"></param>
protected override void OnModelCreating
(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Configurations.Add(new Country.Configuration());
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
/*modelBuilder.Entity<ResoultSaveModel>().HasKey(i => i.Id);
* modelBuilder.Entity<ResoultSaveModel>().Property(i => i.Mark);
* modelBuilder.Entity<ResoultSaveModel>().Property(i => i.UserName);
* modelBuilder.Entity<ResoultSaveModel>().Property(i => i.Started);
* modelBuilder.Entity<ResoultSaveModel>().Property(i => i.Finished);*/
modelBuilder.Entity <TestModel>().HasKey(i => i.Id);
modelBuilder.Entity <TestModel>().Property(i => i.title);
modelBuilder.Entity <TestModel>().Property(i => i.Description);
modelBuilder.Entity <TestModel>().HasMany(i => i.Questions)
.WithRequired()
.HasForeignKey(si => si.TestId);
modelBuilder.Entity <Question>().HasKey(i => i.QuestionId);
modelBuilder.Entity <Question>().Property(i => i.Text);
modelBuilder.Entity <Question>().HasMany(i => i.Answers)
.WithRequired()
.HasForeignKey(si => si.QuestionId);
modelBuilder.Entity <AnswerVariant>().HasKey(i => i.AnswerId);
modelBuilder.Entity <AnswerVariant>().Property(i => i.Text);
}
/// <summary>
/// Define the relations between tables
/// </summary>
/// <param name="modelBuilder"></param>
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <Patient>().HasMany(x => x.DentalProcedures);
modelBuilder.Entity <Patient>().HasMany(x => x.Diseases);
modelBuilder.Entity <ProceduresTable>().HasMany(x => x.Cells);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Configurations.Add(new AdminReMapping());
modelBuilder.Configurations.Add(new ApplicationLogMapping());
modelBuilder.Configurations.Add(new CustomerMapping());
modelBuilder.Configurations.Add(new EmployeeMapping());
modelBuilder.Configurations.Add(new IngredientMapping());
modelBuilder.Configurations.Add(new OrderNoteMapping());
modelBuilder.Configurations.Add(new OrderNoteDetailMapping());
modelBuilder.Configurations.Add(new ProductMapping());
modelBuilder.Configurations.Add(new ProductDetailMapping());
modelBuilder.Configurations.Add(new ReceiptNoteMapping());
modelBuilder.Configurations.Add(new ReceiptNoteDetailMapping());
modelBuilder.Configurations.Add(new SalaryNoteMapping());
modelBuilder.Configurations.Add(new WareHouseMapping());
modelBuilder.Configurations.Add(new WorkingHistoryMapping());
modelBuilder.Configurations.Add(new APWareHouseMapping());
modelBuilder.Configurations.Add(new StockMapping());
modelBuilder.Configurations.Add(new StockInMapping());
modelBuilder.Configurations.Add(new StockInDetailsMapping());
modelBuilder.Configurations.Add(new StockOutMapping());
modelBuilder.Configurations.Add(new StockOutDetailsMapping());
OnModelCreatingPartial(modelBuilder);
}
public static System.Data.Entity.DbModelBuilder CreateModel(System.Data.Entity.DbModelBuilder modelBuilder, string schema)
{
modelBuilder.Configurations.Add(new AdminReMapping(schema));
modelBuilder.Configurations.Add(new ApplicationLogMapping(schema));
modelBuilder.Configurations.Add(new CustomerMapping(schema));
modelBuilder.Configurations.Add(new EmployeeMapping(schema));
modelBuilder.Configurations.Add(new IngredientMapping(schema));
modelBuilder.Configurations.Add(new OrderNoteMapping(schema));
modelBuilder.Configurations.Add(new OrderNoteDetailMapping(schema));
modelBuilder.Configurations.Add(new ProductMapping(schema));
modelBuilder.Configurations.Add(new ProductDetailMapping(schema));
modelBuilder.Configurations.Add(new ReceiptNoteMapping(schema));
modelBuilder.Configurations.Add(new ReceiptNoteDetailMapping(schema));
modelBuilder.Configurations.Add(new SalaryNoteMapping(schema));
modelBuilder.Configurations.Add(new WareHouseMapping(schema));
modelBuilder.Configurations.Add(new WorkingHistoryMapping(schema));
modelBuilder.Configurations.Add(new APWareHouseMapping(schema));
modelBuilder.Configurations.Add(new StockMapping(schema));
modelBuilder.Configurations.Add(new StockInMapping(schema));
modelBuilder.Configurations.Add(new StockInDetailsMapping(schema));
modelBuilder.Configurations.Add(new StockOutMapping(schema));
modelBuilder.Configurations.Add(new StockOutDetailsMapping(schema));
return(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
//modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>();
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
//base.OnModelCreating(modelBuilder);
if (modelBuilder == null)
{
throw new ArgumentNullException("modelBuilder");
}
// Keep this:
modelBuilder.Entity <IdentityUser>().ToTable("AspNetUsers");
modelBuilder.Entity <IdentityUser>().HasMany <IdentityUserRole>((IdentityUser u) => u.Roles);
modelBuilder.Entity <IdentityUserRole>().HasKey((IdentityUserRole r) =>
new { UserId = r.UserId, RoleId = r.RoleId }).ToTable("AspNetUserRoles");
// Leave this alone:
EntityTypeConfiguration <IdentityUserLogin> entityTypeConfiguration =
modelBuilder.Entity <IdentityUserLogin>().HasKey((IdentityUserLogin l) =>
new
{
UserId = l.UserId,
LoginProvider = l.LoginProvider,
ProviderKey
= l.ProviderKey
}).ToTable("AspNetUserLogins");
EntityTypeConfiguration <IdentityUserClaim> table1 =
modelBuilder.Entity <IdentityUserClaim>().ToTable("AspNetUserClaims");
// Add this, so that IdentityRole can share a table with ApplicationRole:
modelBuilder.Entity <IdentityRole>().ToTable("AspNetRoles");
modelBuilder.Configurations.Add(new BarConfiguration());
modelBuilder.Configurations.Add(new FundConfiguration());
}
//
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <HomeVisit>().Property(x => x.GeoLat).HasPrecision(12, 8);
modelBuilder.Entity <HomeVisit>().Property(x => x.GeoLng).HasPrecision(12, 8);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <Utilizator>().ToTable("Utilizatori");
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(Entity.DbModelBuilder modelBuilder)
{
// Register all mappings from current assembly
modelBuilder.Configurations.AddFromAssembly(GetType().Assembly);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
//configure primary keys first
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Attendence>().HasKey(p => p.AttendenceId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Attendence>()
.HasRequired(p => p.Student).WithMany(p => p.Attendences).HasForeignKey(p => p.StudentId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Attendence>()
.HasRequired(p => p.Course).WithMany(p => p.Attendences).HasForeignKey(p => p.CourseId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Attendence>()
.HasRequired(p => p.TimeTable).WithMany().HasForeignKey(p => p.TimeTableId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Course>().HasKey(p => p.CourseId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.CourseScedule>().HasKey(p => p.CourseSceduleId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.CourseScedule>().HasRequired(p => p.TimeTable).WithMany().HasForeignKey(p => p.TimeTableId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Department>().HasKey(p => p.DepartmentId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Department>().HasRequired(p => p.FileStorage).WithMany().HasForeignKey(p => p.FileStorageId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.DepartmentCourse>().HasKey(p => p.DepartmentCourseId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.DepartmentCourse>().HasRequired(p => p.Department).WithMany().HasForeignKey(p => p.DepartmentId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.DepartmentCourse>().HasRequired(p => p.Course).WithMany().HasForeignKey(p => p.CourseId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Employee>().HasKey(p => p.EmployeeId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Event>().HasKey(p => p.EventId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Event>().HasRequired(p => p.EventTime).WithMany().HasForeignKey(p => p.EventTimeTableId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.FileStorage>().HasKey(p => p.FileStorageId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Grade>().HasKey(p => p.GradeId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.News>().HasKey(p => p.NewsId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Result>().HasKey(p => p.ResultId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Result>().HasRequired(p => p.Student).WithMany().HasForeignKey(p => p.StudentId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Result>().HasRequired(p => p.Course).WithMany().HasForeignKey(p => p.CourseId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Result>().HasRequired(p => p.TimeTable).WithMany().HasForeignKey(p => p.TimeTableId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.Student>().HasKey(p => p.StudentId);
modelBuilder.Entity <University.Service.Areas.HelpPage.Models.User>().HasOptional(p => p.UserRole).WithMany(p => p.Users).HasForeignKey(p => p.UserRoleId);
modelBuilder.Entity <IdentityUserLogin>().HasKey <string>(l => l.UserId);
modelBuilder.Entity <IdentityRole>().HasKey <string>(r => r.Id);
modelBuilder.Entity <IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId });
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <global::Sandbox_EF6.Role>()
.ToTable("Roles")
.HasKey(t => t.Id);
modelBuilder.Entity <global::Sandbox_EF6.Role>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::Sandbox_EF6.User>()
.ToTable("Users")
.HasKey(t => t.Id);
modelBuilder.Entity <global::Sandbox_EF6.User>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::Sandbox_EF6.User>()
.HasRequired(x => x.Role)
.WithMany(x => x.Users)
.Map(x => x.MapKey("Role_Id"));
OnModelCreatedImpl(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <TestLangTable>().ToTable("TestLangTable");
modelBuilder.Entity <TestLangTable2>().ToTable("TestLangTable2");
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Dad>()
.Property(x => x.DayOfBirth).IsRequired();
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <global::MultiContext.Context1.Entity1>()
.ToTable("Entity1")
.HasKey(t => t.Id);
modelBuilder.Entity <global::MultiContext.Context1.Entity1>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::MultiContext.Context1.Entity2>()
.ToTable("Entity2")
.HasKey(t => t.Id);
modelBuilder.Entity <global::MultiContext.Context1.Entity2>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::MultiContext.Context1.Entity2>()
.HasRequired(x => x.Entity1)
.WithMany(x => x.Entity2)
.Map(x => x.MapKey("Entity1_Id"));
OnModelCreatedImpl(modelBuilder);
}
//public DbSet<Contact> InquirySheet { get; set; }
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
//里继承了DbContext,这个基类和下面的DbSet<>都是用于Code First模式的，当然DataBase First也可以用。同时我们要重写OnModelCreating()方法，在这个方法里移除表名复数的契约。比如我们在这里Model叫Movie，如果不加modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();这句话，在数据库表中表名会被设置为Movies。这种情况下，就需要移除这个契约。
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
// 禁用一对多级联删除
// modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
// 禁用多对多级联删除
//modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>();
// modelBuilder.Conventions.Remove<IncludeMetadataConvention>();
//modelBuilder.HasDefaultSchema("public");
//modelBuilder.Configurations.Add(new ProductNMMap());
//modelBuilder.Configurations.Add(new ContactConfiguration());
#region 权限
modelBuilder.Configurations.Add(new PermissionRoleConfigurationMap());
modelBuilder.Configurations.Add(new PermissionModuleConfigurationMap());
modelBuilder.Configurations.Add(new PermissionReRoleModuleConfigurationMap());
modelBuilder.Configurations.Add(new UserMap());
modelBuilder.Configurations.Add(new UserReRoleMap());
#endregion
//modelBuilder.Configurations.Add(new ResortMap());
//modelBuilder.Entity<Contact>().MapToStoredProcedures();
//modelBuilder.Configurations.Add(new CategoryMap());
//modelBuilder.Configurations.Add(new ProductMap());
//modelBuilder.ComplexType<Address>();
//modelBuilder.Configurations.Add(new EmployeeMap());
//modelBuilder.Configurations.Add(new LodgingMap());
//modelBuilder.Configurations.Add(new DestinationMap());
//modelBuilder.Configurations.Add(new ReferenceProductConfiguration());
//modelBuilder.Configurations.Add(new BlogConfiguration());
//modelBuilder.Configurations.Add(new PostConfiguration());
//modelBuilder.Configurations.Add(new ActivityMap());
base.OnModelCreating(modelBuilder);
// modelBuilder.Conventions.Remove)
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove <ManyToManyCascadeDeleteConvention>();
modelBuilder.Entity <Student>().HasMany(x => x.Courses)
.WithMany(y => y.Students);
modelBuilder.Entity <AutomaticTest>().HasMany(x => x.CloseQuestions)
.WithMany(y => y.AutomaticTests);
modelBuilder.Entity <Teacher>().HasMany(m => m.Courses);
modelBuilder.Entity <ManualTest>().HasMany(x => x.CloseQuestions)
.WithMany(y => y.ManualTests);
modelBuilder.Entity <ManualTest>().HasMany(x => x.OpenQuestions)
.WithMany(y => y.ManualTests);
modelBuilder.Entity <SolvedCloseQuestion>().HasMany(x => x.SelectedAnswers)
.WithMany();
modelBuilder.Entity <Student>()
.HasMany(x => x.CourseLevels).WithMany();
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
// Database does not pluralize table names
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
modelBuilder.Entity <PayTo>().HasRequired(x => x.Teammate).WithMany(x => x.PayTos).HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <Teammate>().HasRequired(x => x.Team).WithMany(x => x.Teammates).HasForeignKey(x => x.TeamId);
modelBuilder.Entity <Tx>().HasRequired(x => x.Teammate).WithMany().HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <Tx>().HasOptional(x => x.ClaimTeammate).WithMany().HasForeignKey(x => x.ClaimTeammateId);
modelBuilder.Entity <Tx>().HasOptional(x => x.MoveToAddress).WithMany(x => x.MoveFundsTxs).HasForeignKey(x => x.MoveToAddressId);
modelBuilder.Entity <TxInput>().HasRequired(x => x.Tx).WithMany(x => x.Inputs).HasForeignKey(x => x.TxId);
modelBuilder.Entity <TxOutput>().HasRequired(x => x.Tx).WithMany(x => x.Outputs).HasForeignKey(x => x.TxId);
modelBuilder.Entity <TxOutput>().HasOptional(x => x.PayTo).WithMany().HasForeignKey(x => x.PayToId);
modelBuilder.Entity <TxSignature>().HasRequired(x => x.TxInput).WithMany(x => x.Signatures).HasForeignKey(x => x.TxInputId);
modelBuilder.Entity <TxSignature>().HasRequired(x => x.Teammate).WithMany().HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <BtcAddress>().HasKey(x => x.Address);
modelBuilder.Entity <BtcAddress>().HasRequired(x => x.Teammate).WithMany(x => x.Addresses).HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <Cosigner>().HasKey(x => new { x.AddressId, x.KeyOrder });
modelBuilder.Entity <Cosigner>().HasRequired(x => x.Address).WithMany(x => x.Cosigners).HasForeignKey(x => x.AddressId);
modelBuilder.Entity <Cosigner>().HasRequired(x => x.Teammate).WithMany(x => x.CosignerOf).HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <Disbanding>().HasRequired(x => x.Teammate).WithMany(x => x.Disbandings).HasForeignKey(x => x.TeammateId);
modelBuilder.Entity <DisbandingTxSignature>().HasRequired(x => x.Cosigner).WithMany(x => x.DisbandingTxSignatures).HasForeignKey(x => new { x.AddressId, x.KeyOrder });
modelBuilder.Entity <DisbandingTxSignature>().HasRequired(x => x.Address).WithMany().HasForeignKey(x => x.AddressId);
}
public static System.Data.Entity.DbModelBuilder CreateModel(System.Data.Entity.DbModelBuilder modelBuilder, string schema)
{
modelBuilder.Configurations.Add(new AlphabeticalListOfProductConfiguration(schema));
modelBuilder.Configurations.Add(new CategoryConfiguration(schema));
modelBuilder.Configurations.Add(new CategorySalesFor1997Configuration(schema));
modelBuilder.Configurations.Add(new CurrentProductListConfiguration(schema));
modelBuilder.Configurations.Add(new CustomerConfiguration(schema));
modelBuilder.Configurations.Add(new CustomerAndSuppliersByCityConfiguration(schema));
modelBuilder.Configurations.Add(new CustomerDemographicConfiguration(schema));
modelBuilder.Configurations.Add(new EmployeeConfiguration(schema));
modelBuilder.Configurations.Add(new InvoiceConfiguration(schema));
modelBuilder.Configurations.Add(new OrderConfiguration(schema));
modelBuilder.Configurations.Add(new OrderDetailConfiguration(schema));
modelBuilder.Configurations.Add(new OrderDetailsExtendedConfiguration(schema));
modelBuilder.Configurations.Add(new OrdersQryConfiguration(schema));
modelBuilder.Configurations.Add(new OrderSubtotalConfiguration(schema));
modelBuilder.Configurations.Add(new ProductConfiguration(schema));
modelBuilder.Configurations.Add(new ProductsAboveAveragePriceConfiguration(schema));
modelBuilder.Configurations.Add(new ProductSalesFor1997Configuration(schema));
modelBuilder.Configurations.Add(new ProductsByCategoryConfiguration(schema));
modelBuilder.Configurations.Add(new RegionConfiguration(schema));
modelBuilder.Configurations.Add(new SalesByCategoryConfiguration(schema));
modelBuilder.Configurations.Add(new SalesTotalsByAmountConfiguration(schema));
modelBuilder.Configurations.Add(new ShipperConfiguration(schema));
modelBuilder.Configurations.Add(new SummaryOfSalesByQuarterConfiguration(schema));
modelBuilder.Configurations.Add(new SummaryOfSalesByYearConfiguration(schema));
modelBuilder.Configurations.Add(new SupplierConfiguration(schema));
modelBuilder.Configurations.Add(new TerritoryConfiguration(schema));
return(modelBuilder);
}
/// <summary>
/// This method is called when the model for a derived context has been initialized, but
/// before the model has been locked down and used to initialize the context. The default
/// implementation of this method does nothing, but it can be overridden in a derived class
/// such that the model can be further configured before it is locked down.
/// </summary>
/// <param name="modelBuilder">The builder that defines the model for the context being created.</param>
/// <remarks>
/// Typically, this method is called only once when the first instance of a derived context
/// is created. The model for that context is then cached and is for all further instances of
/// the context in the app domain. This caching can be disabled by setting the ModelCaching
/// property on the given ModelBuidler, but note that this can seriously degrade performance.
/// More control over caching is provided through use of the DbModelBuilder and DbContextFactory
/// classes directly.
/// </remarks>
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
InheritanceMapping(modelBuilder);
MapEntity <CategoryItemRelation>(modelBuilder, toTable: "CategoryItemRelation");
MapEntity <ItemAsset>(modelBuilder, toTable: "ItemAsset");
MapEntity <Association>(modelBuilder, toTable: "Association");
MapEntity <AssociationGroup>(modelBuilder, toTable: "AssociationGroup");
MapEntity <CatalogLanguage>(modelBuilder, toTable: "CatalogLanguage");
MapEntity <EditorialReview>(modelBuilder, toTable: "EditorialReview");
MapEntity <ItemRelation>(modelBuilder, toTable: "ItemRelation");
MapEntity <Price>(modelBuilder, toTable: "Price");
MapEntity <Pricelist>(modelBuilder, toTable: "Pricelist");
MapEntity <PricelistAssignment>(modelBuilder, toTable: "PricelistAssignment");
MapEntity <Property>(modelBuilder, toTable: "Property");
MapEntity <PropertyAttribute>(modelBuilder, toTable: "PropertyAttribute");
MapEntity <PropertySet>(modelBuilder, toTable: "PropertySet");
MapEntity <PropertySetProperty>(modelBuilder, toTable: "PropertySetProperty");
MapEntity <Packaging>(modelBuilder, toTable: "Packaging");
MapEntity <TaxCategory>(modelBuilder, toTable: "TaxCategory");
// Introducing FOREIGN KEY constraint 'FK_dbo.Association_dbo.Item_ItemId' on table 'Association' may cause cycles or multiple cascade paths.
modelBuilder.Entity <Association>().HasRequired(m => m.CatalogItem).WithMany().WillCascadeOnDelete(false);
modelBuilder.Entity <CategoryItemRelation>().HasRequired(p => p.Category).WithMany().WillCascadeOnDelete(false);
modelBuilder.Entity <ItemRelation>().HasRequired(m => m.ChildItem).WithMany().WillCascadeOnDelete(false);
// cascade delete Item and Category when PropertySet is deleted. This should happen ONLY when catalog is being deleted.
modelBuilder.Entity <Item>().HasOptional(m => m.PropertySet).WithMany().WillCascadeOnDelete(false);
modelBuilder.Entity <Category>().HasOptional(m => m.PropertySet).WithMany().WillCascadeOnDelete(false);
base.OnModelCreating(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Configurations.Add(new AlphabeticalListOfProductConfiguration());
modelBuilder.Configurations.Add(new CategoryConfiguration());
modelBuilder.Configurations.Add(new CategorySalesFor1997Configuration());
modelBuilder.Configurations.Add(new CurrentProductListConfiguration());
modelBuilder.Configurations.Add(new CustomerConfiguration());
modelBuilder.Configurations.Add(new CustomerAndSuppliersByCityConfiguration());
modelBuilder.Configurations.Add(new CustomerDemographicConfiguration());
modelBuilder.Configurations.Add(new EmployeeConfiguration());
modelBuilder.Configurations.Add(new InvoiceConfiguration());
modelBuilder.Configurations.Add(new OrderConfiguration());
modelBuilder.Configurations.Add(new OrderDetailConfiguration());
modelBuilder.Configurations.Add(new OrderDetailsExtendedConfiguration());
modelBuilder.Configurations.Add(new OrdersQryConfiguration());
modelBuilder.Configurations.Add(new OrderSubtotalConfiguration());
modelBuilder.Configurations.Add(new ProductConfiguration());
modelBuilder.Configurations.Add(new ProductsAboveAveragePriceConfiguration());
modelBuilder.Configurations.Add(new ProductSalesFor1997Configuration());
modelBuilder.Configurations.Add(new ProductsByCategoryConfiguration());
modelBuilder.Configurations.Add(new RegionConfiguration());
modelBuilder.Configurations.Add(new SalesByCategoryConfiguration());
modelBuilder.Configurations.Add(new SalesTotalsByAmountConfiguration());
modelBuilder.Configurations.Add(new ShipperConfiguration());
modelBuilder.Configurations.Add(new SummaryOfSalesByQuarterConfiguration());
modelBuilder.Configurations.Add(new SummaryOfSalesByYearConfiguration());
modelBuilder.Configurations.Add(new SupplierConfiguration());
modelBuilder.Configurations.Add(new TerritoryConfiguration());
OnModelCreatingPartial(modelBuilder);
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <global::Sandbox_EF6.BaseClass>()
.ToTable("BaseClasses")
.HasKey(t => t.Id);
modelBuilder.Entity <global::Sandbox_EF6.BaseClass>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::Sandbox_EF6.Detail>()
.ToTable("Details");
modelBuilder.Entity <global::Sandbox_EF6.Detail>()
.HasMany(x => x.BaseClasses)
.WithRequired()
.Map(x => x.MapKey("Detail.BaseClasses_Id"));
modelBuilder.Entity <global::Sandbox_EF6.Master>()
.ToTable("Masters");
modelBuilder.Entity <global::Sandbox_EF6.Master>()
.HasMany(x => x.Details)
.WithOptional()
.Map(x => x.MapKey("Master.Details_Id"))
.WillCascadeOnDelete(true);
OnModelCreatedImpl(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Conventions.Remove <System.Data.Entity.ModelConfiguration.Conventions.PluralizingTableNameConvention>();
modelBuilder.Conventions.Remove <System.Data.Entity.ModelConfiguration.Conventions.OneToManyCascadeDeleteConvention>();
modelBuilder.Conventions.Remove <System.Data.Entity.ModelConfiguration.Conventions.ManyToManyCascadeDeleteConvention>();
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity1>()
.ToTable("Entity1")
.HasKey(t => t.Id);
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity1>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity2>()
.ToTable("Entity2")
.HasKey(t => t.Id);
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity2>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity2>()
.Property(t => t.FK)
.HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute()));
modelBuilder.Entity <global::Sandbox_EF6_Test.Entity2>()
.HasOptional(x => x.Entity1)
.WithMany(x => x.Entity2)
.HasForeignKey(p => p.FK);
OnModelCreatedImpl(modelBuilder);
}
/// <summary>
/// Define the relations between tables
/// </summary>
/// <param name="modelBuilder"></param>
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.Entity <ApplicationUser>().HasMany(x => x.SecurityGroups).WithMany(x => x.ApplicationUsers);
modelBuilder.Entity <ApplicationUser>().HasMany(x => x.Events);
modelBuilder.Entity <SecurityGroup>().HasMany(x => x.Rights).WithMany();
modelBuilder.Entity <Organisation>().HasMany(x => x.Items);
modelBuilder.Entity <Organisation>().HasMany(x => x.Sites);
modelBuilder.Entity <RequestToAcquireItems>().HasMany(x => x.Items).WithMany();
modelBuilder.Entity <RequestToAcquireItems>().HasMany(x => x.CountSelectedItems).WithOptional().WillCascadeOnDelete(true);
modelBuilder.Entity <AssetHistory>().HasKey(x => x.AssetId);
modelBuilder.Entity <AssetHistory>().HasMany(x => x.Rows);
modelBuilder.Entity <Site>().HasMany(x => x.Assets);
modelBuilder.Entity <PackingSlip>().Property(f => f.DateOfGiven).HasColumnType("datetime2");
modelBuilder.Entity <PackingSlip>().Property(f => f.DateOfReceived).HasColumnType("datetime2");
modelBuilder.Entity <RequestForAsset>().HasMany(x => x.Assets).WithMany();
modelBuilder.Entity <RequestForAsset>().HasMany(x => x.ApprovedAssets).WithMany().Map(x => x.ToTable("RequestForAssetApprovedAssets"));
modelBuilder.Entity <RequestForAsset>().HasMany(x => x.GivenAssets).WithMany().Map(x => x.ToTable("RequestForAssetGivenAssets"));
modelBuilder.Entity <RequestToProvider>().HasMany(x => x.SendOffers);
modelBuilder.Entity <RequestToProvider>().HasMany(x => x.WantItems).WithMany();
modelBuilder.Entity <RequestToProvider>().HasMany(x => x.CountItems);
modelBuilder.Entity <RequestToProvider>().HasMany(x => x.GiveItems).WithMany().Map(x => x.ToTable("RequesToProviderGiveItems"));
modelBuilder.Conventions.Remove <ManyToManyCascadeDeleteConvention>();
modelBuilder.Entity <Invoice>().HasMany(x => x.Items).WithMany();
modelBuilder.Entity <Invoice>().Property(f => f.DateOfApproving).HasColumnType("datetime2");
modelBuilder.Entity <Invoice>().Property(f => f.DateOfCreation).HasColumnType("datetime2");
modelBuilder.Entity <Invoice>().Property(f => f.DateOfPayment).HasColumnType("datetime2");
modelBuilder.Entity <Invoice>().Property(f => f.PaymentPeriod).HasColumnType("datetime2");
modelBuilder.Entity <Accident>().Property(f => f.DateOfSend).HasColumnType("datetime2");
modelBuilder.Entity <Accident>().Property(f => f.ReplyingDate).HasColumnType("datetime2");
modelBuilder.Entity <Provider>().HasRequired(x => x.Organisation).WithMany()
.WillCascadeOnDelete(false);
modelBuilder.Entity <Currency>().HasRequired(x => x.Organisation).WithMany()
.WillCascadeOnDelete(false);
modelBuilder.Entity <Location>().HasRequired(x => x.Organisation).WithMany()
.WillCascadeOnDelete(false);
modelBuilder.Entity <ExchangeRate>().HasRequired(x => x.Organisation).WithMany()
.WillCascadeOnDelete(false);
base.OnModelCreating(modelBuilder);
}
