public void Delete(Product product)
{
ProductClassificationEntities context = CreateContext();
context.Entry(product).State = EntityState.Deleted;
context.SaveChanges();
}
public ProductClassificationEntities CreateContext()
{
ProductClassificationEntities context = new ProductClassificationEntities();
context.Configuration.ProxyCreationEnabled = false;
context.Database.Log = x => Console.WriteLine(x);
return(context);
}
public int GetMaxId()
{
ProductClassificationEntities context = CreateContext();
var query = from x in context.Products
orderby x.ProductId descending
select x.ProductId;
return(query.FirstOrDefault());
}
public int GetCount()
{
ProductClassificationEntities context = CreateContext();
return(context.Products.Count());
}
public Product Get(int productId)
{
ProductClassificationEntities context = CreateContext();
return(context.Products.FirstOrDefault(x => x.ProductId == productId));
}
public List <Product> GetAll()
{
ProductClassificationEntities context = CreateContext();
return(context.Products.ToList());
}
