public List <Customer> GetCustomersList()
{
using (ExempleDbContext context = new ExempleDbContext())
{
context.Database.Log = x => Debug.WriteLine(x);
var result = from c in context.Customers
select c;
return(result.ToList());
}
}
public Customer GetFirstCustomer()
{
using (ExempleDbContext context = new ExempleDbContext())
{
context.Database.Log = x => Debug.WriteLine(x);
var result = from c in context.Customers
select c;
return(result.FirstOrDefault());
}
}
public IQueryable <Order> GetOrders()
{
ExempleDbContext context = new ExempleDbContext();
context.Database.Log = x => Debug.WriteLine(x);
var result = context.Orders;
return(result);
}
public IQueryable <IExempleProduct> GetProducts()
{
ExempleDbContext context = new ExempleDbContext();
context.Database.Log = x => Debug.WriteLine(x);
var result = context.Products;
return(result.Select <Product, IExempleProduct>());
}
public IQueryable <Customer> GetCustomers()
{
//It's only un exemple ,don't use in normal development
ExempleDbContext context = new ExempleDbContext();
context.Database.Log = x => Debug.WriteLine(x);
var result = from c in context.Customers
select c;
return(result);
}
public Order GetFirstOrder()
{
using (ExempleDbContext context = new ExempleDbContext())
{
context.Database.Log = x => Debug.WriteLine(x);
//Need to include the sub object
var result = context.Orders
.Include("Customer")
.Include("OrderDetails");
return(result.FirstOrDefault());
}
}