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 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 IQueryable<Order> GetOrders()
{
ExempleDbContext context = new ExempleDbContext();
context.Database.Log = x => Debug.WriteLine(x);
var result = context.Orders;
return result;
}
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 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();
}
}