/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <Sandbox.Entity3>()
.ToTable("Entity3")
.HasKey(t => t.Id);
modelBuilder.Entity <Sandbox.Entity3>()
.Property(t => t.Id)
.IsRequired()
.HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute()))
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Sandbox.Entity3>()
.Property(t => t.Property2)
.HasMaxLength(2)
.HasColumnType("varchar");
modelBuilder.Entity <Sandbox.Entity3>()
.Property(t => t.Property3)
.HasMaxLength(9);
OnModelCreatedImpl(modelBuilder);
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <Sandbox.Entity1>()
.ToTable("Entity1")
.HasKey(t => t.Id);
modelBuilder.Entity <Sandbox.Entity1>()
.Property(t => t.Id)
.IsRequired()
.HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute()))
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Sandbox.Entity1>()
.HasMany(x => x.Entity2)
.WithRequired()
.Map(x => x.MapKey("Entity1_Id"));
modelBuilder.Entity <Sandbox.Entity1>()
.HasRequired(x => x.Entity2_1)
.WithMany(x => x.Entity1)
.Map(x => x.MapKey("Entity2_1_Id"));
modelBuilder.Entity <Sandbox.Entity2>()
.ToTable("Entity2")
.HasKey(t => t.Id);
modelBuilder.Entity <Sandbox.Entity2>()
.Property(t => t.Id)
.IsRequired()
.HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute()))
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
OnModelCreatedImpl(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.HasDefaultSchema("UniOpet");
// Configure Asp Net Identity Tables
modelBuilder.Entity <Models.User>().ToTable("Users");
modelBuilder.Entity <Models.Role>().ToTable("Roles");
}
/// <summary>
/// 模型配置重写
/// </summary>
/// <param name="modelBuilder">数据实体生成器</param>
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
//兼容oracle，需要设置默认schema
if (this.Database.Connection.GetType().Name.Equals("OracleConnection"))
{
string schema = Regex.Match(this.Database.Connection.ConnectionString, @"[User Id,uid]=([^;]+)").Groups[1].Value;
modelBuilder.HasDefaultSchema(schema);
}
// 禁用一对多级联删除
modelBuilder.Conventions.Remove <OneToManyCascadeDeleteConvention>();
// 禁用多对多级联删除
modelBuilder.Conventions.Remove <ManyToManyCascadeDeleteConvention>();
// 禁用表名自动复数规则
modelBuilder.Conventions.Remove <PluralizingTableNameConvention>();
ConfigurationFactory.ConfigurationsInit(modelBuilder.Configurations);
}
/// <inheritdoc />
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <global::ModelEFCore.po>()
.ToTable("poes")
.HasKey(t => t.Id);
modelBuilder.Entity <global::ModelEFCore.po>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::ModelEFCore.po>()
.HasOptional(x => x.poVendor)
.WithMany()
.Map(x => x.MapKey("poVendor_Id"));
modelBuilder.Entity <global::ModelEFCore.poItem>()
.ToTable("poItems")
.HasKey(t => t.Id);
modelBuilder.Entity <global::ModelEFCore.poItem>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <global::ModelEFCore.poItem>()
.HasRequired(x => x.po)
.WithMany(x => x.poItems)
.Map(x => x.MapKey("po_Id"));
modelBuilder.Entity <global::ModelEFCore.vendor>()
.ToTable("vendors")
.HasKey(t => t.Id);
modelBuilder.Entity <global::ModelEFCore.vendor>()
.Property(t => t.Id)
.IsRequired()
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
OnModelCreatedImpl(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.HasDefaultSchema("Tsubasa");
modelBuilder.Entity <UserLogin>().Map(c =>
{
c.ToTable("UserLogin");
c.Properties(p => new
{
p.UserId,
p.LoginProvider,
p.ProviderKey
});
}).HasKey(p => new { p.LoginProvider, p.ProviderKey, p.UserId });
// Mapping for ApiRole
modelBuilder.Entity <Role>().Map(c =>
{
c.ToTable("Role");
c.Property(p => p.Id).HasColumnName("RoleId");
c.Properties(p => new
{
p.Name
});
}).HasKey(p => p.Id);
modelBuilder.Entity <Role>().HasMany(c => c.Users).WithRequired().HasForeignKey(c => c.RoleId);
modelBuilder.Entity <User>().Map(c =>
{
c.ToTable("User");
c.Property(p => p.Id).HasColumnName("UserId");
c.Properties(p => new
{
p.AccessFailedCount,
p.Email,
p.EmailConfirmed,
p.PasswordHash,
p.PhoneNumber,
p.PhoneNumberConfirmed,
p.TwoFactorEnabled,
p.SecurityStamp,
p.LockoutEnabled,
p.LockoutEndDateUtc,
p.UserName
});
}).HasKey(c => c.Id);
modelBuilder.Entity <User>().HasMany(c => c.Logins).WithOptional().HasForeignKey(c => c.UserId);
modelBuilder.Entity <User>().HasMany(c => c.Claims).WithOptional().HasForeignKey(c => c.UserId);
modelBuilder.Entity <User>().HasMany(c => c.Roles).WithRequired().HasForeignKey(c => c.UserId);
modelBuilder.Entity <UserRole>().Map(c =>
{
c.ToTable("UserRole");
c.Properties(p => new
{
p.UserId,
p.RoleId
});
})
.HasKey(c => new { c.UserId, c.RoleId });
modelBuilder.Entity <UserClaim>().Map(c =>
{
c.ToTable("UserClaim");
c.Property(p => p.Id).HasColumnName("UserClaimId");
c.Properties(p => new
{
p.UserId,
p.ClaimValue,
p.ClaimType
});
}).HasKey(c => c.Id);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
OnModelCreatingImpl(modelBuilder);
modelBuilder.HasDefaultSchema("dbo");
modelBuilder.Entity <Testing.AllPropertyTypesOptional>().ToTable("AllPropertyTypesOptionals").HasKey(t => t.Id);
modelBuilder.Entity <Testing.AllPropertyTypesOptional>().Property(t => t.Id).IsRequired().HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.AllPropertyTypesOptional>().Property(t => t.String).HasMaxLength(100);
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().ToTable("AllPropertyTypesRequireds").HasKey(t => t.Id);
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.Id).IsRequired().HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.BinaryAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.BooleanAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.ByteAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.DateTimeAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.DateTimeOffsetAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.DecimalAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.DoubleAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.GuidAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.Int16Attr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.Int32Attr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.Int64Attr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.SingleAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.TimeAttr).IsRequired();
modelBuilder.Entity <Testing.AllPropertyTypesRequired>().Property(t => t.String).HasMaxLength(100).IsRequired();
modelBuilder.Entity <Testing.BaseClassWithRequiredProperties>().ToTable("BaseClassWithRequiredProperties").HasKey(t => t.Id);
modelBuilder.Entity <Testing.BaseClassWithRequiredProperties>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.BaseClassWithRequiredProperties>().Property(t => t.Property0).IsRequired();
modelBuilder.Entity <Testing.BChild>().ToTable("BChilds").HasKey(t => t.Id);
modelBuilder.Entity <Testing.BChild>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.BChild>().HasRequired(x => x.BParentRequired).WithOptional(x => x.BChildOptional).Map(x => x.MapKey("BParentRequired_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.BChild>().HasRequired(x => x.BParentRequired_1).WithRequiredPrincipal(x => x.BChildRequired).Map(x => x.MapKey("BParentRequired_1_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.BChild>().HasRequired(x => x.BParentRequired_2).WithMany(x => x.BChildCollection).Map(x => x.MapKey("BParentRequired_2_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.BChild>().HasMany(x => x.BParentCollection).WithRequired(x => x.BChildRequired).Map(x => x.MapKey("BChildRequired_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.BChild>().HasMany(x => x.BParentCollection_1).WithMany(x => x.BChildCollection).Map(x => { x.ToTable("BParentCollection_1_x_BChildCollection"); x.MapLeftKey("BParentCollection_Id"); x.MapRightKey("BChild_Id"); });
modelBuilder.Entity <Testing.BChild>().HasMany(x => x.BParentCollection_2).WithOptional(x => x.BChildOptional).Map(x => x.MapKey("BChildOptional_Id"));
modelBuilder.Entity <Testing.BChild>().HasOptional(x => x.BParentOptional).WithRequired(x => x.BChildRequired).Map(x => x.MapKey("BChildRequired1_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.BChild>().HasOptional(x => x.BParentOptional_1).WithMany(x => x.BChildCollection).Map(x => x.MapKey("BParentOptional_1_Id"));
modelBuilder.Entity <Testing.BChild>().HasOptional(x => x.BParentOptional_2).WithOptionalPrincipal(x => x.BChildOptional).Map(x => x.MapKey("BParentOptional_2_Id"));
modelBuilder.Entity <Testing.BParentCollection>().ToTable("BParentCollections").HasKey(t => t.Id);
modelBuilder.Entity <Testing.BParentCollection>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.BParentOptional>().ToTable("BParentOptionals").HasKey(t => t.Id);
modelBuilder.Entity <Testing.BParentOptional>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.BParentRequired>().ToTable("BParentRequireds").HasKey(t => t.Id);
modelBuilder.Entity <Testing.BParentRequired>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.Child>().ToTable("Children").HasKey(t => t.Id);
modelBuilder.Entity <Testing.Child>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.Child>().HasRequired(x => x.Parent).WithMany(x => x.Children).Map(x => x.MapKey("Parent_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.ConcreteDerivedClassWithRequiredProperties>().Property(t => t.Property1).IsRequired();
modelBuilder.Entity <Testing.HiddenEntity>().ToTable("HiddenEntities").HasKey(t => t.Id);
modelBuilder.Entity <Testing.HiddenEntity>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.Master>().ToTable("Masters").HasKey(t => t.Id);
modelBuilder.Entity <Testing.Master>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.Master>().HasMany(x => x.Children).WithRequired().Map(x => x.MapKey("Master_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.ParserTest>().ToTable("ParserTests").HasKey(t => t.Id);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.Id).IsRequired().HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.foo).IsRequired();
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name7).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name8).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name9).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name15).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name16).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name17).HasMaxLength(6);
modelBuilder.Entity <Testing.ParserTest>().Property(t => t.name18).HasMaxLength(6);
modelBuilder.Entity <Testing.SpatialProperties>().ToTable("SpatialProperties").HasKey(t => t.Id);
modelBuilder.Entity <Testing.SpatialProperties>().Property(t => t.Id).IsRequired().HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.UChild>().ToTable("UChilds").HasKey(t => t.Id);
modelBuilder.Entity <Testing.UChild>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.UParentCollection>().ToTable("UParentCollections").HasKey(t => t.Id);
modelBuilder.Entity <Testing.UParentCollection>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.UParentCollection>().HasRequired(x => x.UChildRequired).WithMany().Map(x => x.MapKey("UChildRequired_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.UParentCollection>().HasMany(x => x.UChildCollection).WithMany().Map(x => { x.ToTable("UParentCollection_x_UChildCollection"); x.MapLeftKey("UParentCollection_Id"); x.MapRightKey("UChild_Id"); });
modelBuilder.Entity <Testing.UParentCollection>().HasOptional(x => x.UChildOptional).WithMany().Map(x => x.MapKey("UChildOptional_Id"));
modelBuilder.Entity <Testing.UParentOptional>().HasOptional(x => x.UChildOptional).WithOptionalDependent().Map(x => x.MapKey("UParentOptional_Id"));
modelBuilder.Entity <Testing.UParentOptional>().HasMany(x => x.UChildCollection).WithOptional().Map(x => x.MapKey("UParentOptional1_Id"));
modelBuilder.Entity <Testing.UParentOptional>().HasRequired(x => x.UChildRequired).WithOptional().Map(x => x.MapKey("UChildRequired_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.UParentRequired>().ToTable("UParentRequireds").HasKey(t => t.Id);
modelBuilder.Entity <Testing.UParentRequired>().Property(t => t.Id).IsRequired().HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute())).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity <Testing.UParentRequired>().HasRequired(x => x.UChildRequired).WithRequiredDependent().Map(x => x.MapKey("UParentRequired_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.UParentRequired>().HasMany(x => x.UChildCollection).WithRequired().Map(x => x.MapKey("UParentRequired1_Id")).WillCascadeOnDelete();
modelBuilder.Entity <Testing.UParentRequired>().HasOptional(x => x.UChildOptional).WithRequired().Map(x => x.MapKey("UParentRequired2_Id")).WillCascadeOnDelete();
OnModelCreatedImpl(modelBuilder);
}
protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
{
modelBuilder.HasDefaultSchema("identity");
base.OnModelCreating(modelBuilder);
}
