Plain Old CLR Objects - Entity Framework 6 Recipes - page 259

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}
public DbSet<Customer> Customers { get; set; }
public DbSet<Order> Orders { get; set; }
public DbSet<OrderDetail> OrderDetails { get; set; }
public DbSet<Product> Products { get; set; }
}
This completes the model with the generated POCO classes. The code in Listing 8-3 demonstrates inserting into
and querying our model.
Listing 8-3. Using Our POCO Classes
using (var context = new EFRecipesEntities())
{
var tea = new Product { ProductName = "Green Tea", UnitPrice = 1.09M };
var coffee = new Product
{
ProductName = "Colombian Coffee",
UnitPrice = 2.15M
};
var customer = new Customer { ContactName = "Karen Marlowe" };
var order1 = new Order { OrderDate = DateTime.Parse("10/06/13") };
order1.OrderDetails.Add(new OrderDetail
{
Product = tea,
Quantity = 4,
UnitPrice = 1.00M
});
order1.OrderDetails.Add(new OrderDetail
{
Product = coffee,
Quantity = 3,
UnitPrice = 2.15M
});
customer.Orders.Add(order1);
context.Customers.Add(customer);
context.SaveChanges();
}
using (var context = new EFRecipesEntities())
{
var query = context.Customers.Include("Orders.OrderDetails.Product");
foreach (var customer in query)
{
Console.WriteLine("Orders for {0}", customer.ContactName);
foreach (var order in customer.Orders)
{
Console.WriteLine("--Order Date: {0}--",
order.OrderDate.ToShortDateString());