public static void ConfigureOrders(
this ModelBuilder builder,
Action <OrdersModelBuilderConfigurationOptions> optionsAction = null)
{
Check.NotNull(builder, nameof(builder));
var options = new OrdersModelBuilderConfigurationOptions(
OrdersDbProperties.DbTablePrefix,
OrdersDbProperties.DbSchema
);
optionsAction?.Invoke(options);
/* Configure all entities here. Example:
*
* builder.Entity<Question>(b =>
* {
* //Configure table & schema name
* b.ToTable(options.TablePrefix + "Questions", options.Schema);
*
* b.ConfigureByConvention();
*
* //Properties
* b.Property(q => q.Title).IsRequired().HasMaxLength(QuestionConsts.MaxTitleLength);
*
* //Relations
* b.HasMany(question => question.Tags).WithOne().HasForeignKey(qt => qt.QuestionId);
*
* //Indexes
* b.HasIndex(q => q.CreationTime);
* });
*/
}
public static void ConfigureEShopOrders(
this ModelBuilder builder,
Action <OrdersModelBuilderConfigurationOptions> optionsAction = null)
{
Check.NotNull(builder, nameof(builder));
var options = new OrdersModelBuilderConfigurationOptions(
OrdersDbProperties.DbTablePrefix,
OrdersDbProperties.DbSchema
);
optionsAction?.Invoke(options);
/* Configure all entities here. Example:
*
* builder.Entity<Question>(b =>
* {
* //Configure table & schema name
* b.ToTable(options.TablePrefix + "Questions", options.Schema);
*
* b.ConfigureByConvention();
*
* //Properties
* b.Property(q => q.Title).IsRequired().HasMaxLength(QuestionConsts.MaxTitleLength);
*
* //Relations
* b.HasMany(question => question.Tags).WithOne().HasForeignKey(qt => qt.QuestionId);
*
* //Indexes
* b.HasIndex(q => q.CreationTime);
* });
*/
builder.Entity <Order>(b =>
{
b.ToTable(options.TablePrefix + "Orders", options.Schema);
b.ConfigureByConvention();
/* Configure more properties here */
b.Property(x => x.ProductTotalPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.TotalPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.TotalDiscount).HasColumnType("decimal(20,8)");
b.Property(x => x.ActualTotalPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.RefundAmount).HasColumnType("decimal(20,8)");
b.HasIndex(x => x.OrderNumber).IsUnique();
});
builder.Entity <OrderLine>(b =>
{
b.ToTable(options.TablePrefix + "OrderLines", options.Schema);
b.ConfigureByConvention();
/* Configure more properties here */
b.Property(x => x.TotalPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.TotalDiscount).HasColumnType("decimal(20,8)");
b.Property(x => x.ActualTotalPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.UnitPrice).HasColumnType("decimal(20,8)");
b.Property(x => x.RefundAmount).HasColumnType("decimal(20,8)");
});
}