public List <Product> GetAllProducts()
{
using (var ctx = new ProductEFDbContext(connection))
{
return(ctx.Products.ToList());
}
}
public Product GetById(int id)
{
using (var ctx = new ProductEFDbContext(connection))
{
return(ctx.Products.FirstOrDefault(p => p.Id == id));
}
}
public void Add(Product product)
{
using (var ctx = new ProductEFDbContext(connection))
{
ctx.Products.Add(product);
ctx.SaveChanges();
}
}
