in AdventureWorksMVCCore.Web/Models/CYCLE_STOREContext.cs [33:139]
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Product>(entity =>
{
entity.ToTable("Product", "Production");
entity.Property(e => e.ProductId)
.HasColumnName("ProductID")
.ValueGeneratedNever();
entity.Property(e => e.Class)
.HasMaxLength(2)
.IsFixedLength();
entity.Property(e => e.Color).HasMaxLength(15);
entity.Property(e => e.DiscontinuedDate).HasColumnType("datetime");
entity.Property(e => e.ListPrice).HasColumnType("money");
entity.Property(e => e.ModifiedDate).HasColumnType("datetime");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50);
entity.Property(e => e.ProductLine)
.HasMaxLength(2)
.IsFixedLength();
entity.Property(e => e.ProductModelId).HasColumnName("ProductModelID");
entity.Property(e => e.ProductNumber)
.IsRequired()
.HasMaxLength(25);
entity.Property(e => e.ProductSubcategoryId).HasColumnName("ProductSubcategoryID");
entity.Property(e => e.Rowguid).HasColumnName("rowguid");
entity.Property(e => e.SellEndDate).HasColumnType("datetime");
entity.Property(e => e.SellStartDate).HasColumnType("datetime");
entity.Property(e => e.Size).HasMaxLength(5);
entity.Property(e => e.SizeUnitMeasureCode)
.HasMaxLength(3)
.IsFixedLength();
entity.Property(e => e.StandardCost).HasColumnType("money");
entity.Property(e => e.Style)
.HasMaxLength(2)
.IsFixedLength();
entity.Property(e => e.Weight).HasColumnType("decimal(8, 2)");
entity.Property(e => e.WeightUnitMeasureCode)
.HasMaxLength(3)
.IsFixedLength();
});
modelBuilder.Entity<ProductCategory>(entity =>
{
entity.ToTable("ProductCategory", "Production");
entity.Property(e => e.ProductCategoryId)
.HasColumnName("ProductCategoryID")
.ValueGeneratedNever();
entity.Property(e => e.ModifiedDate).HasColumnType("datetime");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50);
entity.Property(e => e.Rowguid).HasColumnName("rowguid");
});
modelBuilder.Entity<ProductSubcategory>(entity =>
{
entity.ToTable("ProductSubcategory", "Production");
entity.Property(e => e.ProductSubcategoryId)
.HasColumnName("ProductSubcategoryID")
.ValueGeneratedNever();
entity.Property(e => e.ModifiedDate).HasColumnType("datetime");
entity.Property(e => e.Name)
.IsRequired()
.HasMaxLength(50);
entity.Property(e => e.ProductCategoryId).HasColumnName("ProductCategoryID");
entity.Property(e => e.Rowguid).HasColumnName("rowguid");
entity.HasOne(d => d.ProductCategory)
.WithMany(p => p.ProductSubcategory)
.HasForeignKey(d => d.ProductCategoryId)
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("FK_ProductSubcategory_ProductCategory");
});
OnModelCreatingPartial(modelBuilder);
}