//
// read data from DB. this is just a practising excercise for EF.
//
public List <Product> GetProductsDB()
{
var context = new ERPDataStagingDBContext();
List <Product> products = context.Products.ToList();
return(products);
}
// Todo: 1. bulk update, 2. updateDB success?
public void SetProductsDB(List <Product> products)
{
var context = new ERPDataStagingDBContext();
context.Products.AddRange(products);
context.SaveChanges();
}
