protected override void OnModelCreating(DbModelBuilder builder)
{
{
var entity = builder.CreateEntity<SaleHeader>("tc_sale_header");
entity.Property(m => m.NumberText)
.HasColumnName("sale_number")
.IsRequired()
.HasMaxLength(64)
.IsUnicode(false)
.IsVariableLength();
entity.Property(m => m.DayNumber)
.HasColumnName("sale_day_number")
.IsRequired();
entity.Property(m => m.TotalNumber)
.HasColumnName("sale_total_number")
.IsRequired();
entity.Property(m => m.SalesPersonName)
.HasColumnName("sales_person_name")
.IsRequired()
.HasMaxLength(64)
.IsUnicode(true)
.IsVariableLength();
entity.Property(m => m.CustomerName)
.HasColumnName("customer_name")
.IsRequired()
.HasMaxLength(64)
.IsUnicode(true)
.IsVariableLength();
entity.Property(m => m.Status)
.HasColumnName("status")
.IsRequired();
entity.HasMany(m => m.Items)
.WithRequired(m => m._SaleHeader)
.HasForeignKey(m => m._SaleHeaderId)
.WillCascadeOnDelete();
entity.HasMany(m => m.CustomerContacts)
.WithRequired(m => m._SaleHeader)
.HasForeignKey(m => m._SaleHeaderId)
.WillCascadeOnDelete();
}
{
var entity = builder.CreateEntity<SaleLineItem>("tc_sale_line");
entity.Property(m => m.ProductName)
.HasColumnName("product_name")
.IsRequired()
.HasMaxLength(64)
.IsUnicode(true)
.IsVariableLength();
entity.Property(m => m.ProductDescription)
.HasColumnName("product_description")
.IsOptional()
.HasMaxLength(1024)
.IsUnicode(true)
.IsVariableLength();
entity.Property(m => m.Quantity)
.HasColumnName("quantity")
.IsRequired();
entity.Property(m => m.UnitPrice)
.HasColumnName("unit_price")
.IsRequired();
entity.Property(m => m.Status)
.HasColumnName("status")
.IsRequired();
entity.Property(m => m._DynamicProperties)
.HasColumnName("product_detail")
.IsOptional()
.HasColumnType("XML");
entity.Property(m => m._SaleHeaderId)
.HasColumnName("sale_id")
.IsRequired();
entity.HasRequired(m => m._SaleHeader)
.WithMany(m => m.Items)
.HasForeignKey(m => m._SaleHeaderId);
}
{
var entity = builder.CreateEntity<Contact>("tc_customer_contact");
entity.Property(m => m.Method)
.HasColumnName("method")
.IsRequired();
entity.Property(m => m.Value)
.HasColumnName("value")
.IsRequired()
.HasMaxLength(1024)
.IsUnicode(true)
.IsVariableLength();
entity.Property(m => m._SaleHeaderId)
.HasColumnName("sale_id")
.IsRequired();
entity.HasRequired(m => m._SaleHeader)
.WithMany(m => m.CustomerContacts)
.HasForeignKey(m => m._SaleHeaderId);
}
}
