public static void UpdateProduct(NorthWind database)
{
var updateProduct = database.Products.Find(78);
updateProduct.UnitPrice += 20M;
database.SaveChanges();
}
private static void SeeAllProducts(NorthWind database)
{
var price = 5;
IQueryable <Products> query = database.Products.Where(product => product.UnitPrice > price).
OrderByDescending(product => product.UnitPrice);
foreach (var item in query)
{
Console.WriteLine($"{item.ProductID}: {item.ProductName} costs {item.UnitPrice:$#,##0.00}");
}
}
private static void AddNewProduct(NorthWind database)
{
var newProduct = new Products
{
ProductName = "Bob Burger",
UnitPrice = 500M
};
database.Products.Add(newProduct);
database.SaveChanges();
}
private static void Main(string[] args)
{
var database = new NorthWind();
// database.Database.Log = new Action<string>(message => { Console.WriteLine(message); });
SeeAllProducts(database);
Console.ReadLine();
AddNewProduct(database);
SeeAllProducts(database);
Console.ReadLine();
database.Database.Connection.Close();
}
