/// <summary>
/// Get all of the products.
/// </summary>
/// <returns></returns>
public List <EFModels.Product> GetProducts()
{
using (var db = new EFModels.AdventureWorksContext())
{
var products = db.Product
.ToList();
return(products);
}
}
/// <summary>
/// Get a product using the database id.
/// </summary>
/// <param name="productId"></param>
/// <returns></returns>
public EFModels.Product GetProduct(int productId)
{
using (var db = new EFModels.AdventureWorksContext())
{
var product = db.Product
.Where(p => p.ProductId == productId)
.FirstOrDefault();
return(product);
}
}
/// <summary>
/// Get all of the products without EF tracking and sorted in SQL.
/// </summary>
/// <returns></returns>
public List <EFModels.Product> GetProductsSQLOrderBy()
{
using (var db = new EFModels.AdventureWorksContext())
{
var products = db.Product
.OrderBy(p => p.ProductId)
.AsNoTracking()
.ToList();
return(products);
}
}
/// <summary>
/// Get all of the products that match the subcategory id.
/// </summary>
/// <param name="subcategoryId"></param>
/// <returns></returns>
public List <EFModels.Product> GetProductsBySubcategory(int subcategoryId)
{
using (var db = new EFModels.AdventureWorksContext())
{
var products = db.Product
.Where(b => b.ProductSubcategoryId == subcategoryId)
.OrderBy(b => b.ProductNumber)
.Include(p => p.ProductSubcategory)
.ToList();
return(products);
}
}
