protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Customer>().ToTable("Customers");
modelBuilder.Entity <Employee>().ToTable("Employees");
modelBuilder.Entity <Product>().ToTable("Products");
modelBuilder.Entity <Order>().ToTable("Orders");
modelBuilder.Entity <OrderDetail>().ToTable("Order Details");
modelBuilder.Entity <CustomerOrderHistory>().HasKey(coh => coh.ProductName);
modelBuilder.Entity <MostExpensiveProduct>().HasKey(mep => mep.TenMostExpensiveProducts);
#pragma warning disable CS0618 // Type or member is obsolete
modelBuilder.Query <CustomerView>().HasNoKey().ToQuery(
() => CustomerQueries.FromSqlRaw("SELECT * FROM Customers"));
modelBuilder
.Query <OrderQuery>()
.ToQuery(
() => Orders
.FromSqlRaw(@"select * from ""Orders""")
.Select(
o => new OrderQuery
{
CustomerID = o.CustomerID
}));
modelBuilder.Query <ProductQuery>().ToView("Alphabetical list of products");
#pragma warning restore CS0618 // Type or member is obsolete
}