private static void ListProducts() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var productList = dbContext.Products.Include(p => p.ProductType).ToList(); foreach (var product in productList) { Console.WriteLine($"{product.ProductType.Description} {product.Description} {product.FullPrice}"); } } }
private static void ListProductTypes() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var lista = dbContext.ProductTypes.ToList(); foreach (var productType in lista) { Console.WriteLine(productType.Description); } } }
private static void AddingNewProductType() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var productType = new ProductType() { Description = "Who Knocks" }; dbContext.ProductTypes.Add(productType); dbContext.SaveChanges(); } }
private static void ListFilteredProducts() { using (var dbContext = new CoffeeShopDbContext()) { //IQueryable<Product> listProducts = dbContext.Products; //listProducts = listProducts.Where(p => p.FullPrice > 150); dbContext.Database.Log = Console.WriteLine; var productList = dbContext.Products.Where(p => p.FullPrice > 150) .OrderByDescending(p => p.FullPrice) .ToList(); foreach (var product in productList) { Console.WriteLine($"{product.Description} - {product.FullPrice}"); } } }
private static void UpdateProduct() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var productListBeforeUpdate = dbContext.Products.ToList(); DisplayProductList(productListBeforeUpdate); var modifiedProduct = dbContext.Products .SingleOrDefault(p => p.Description == "Medium Coffee"); if (modifiedProduct == null) { return; } modifiedProduct.FullPrice += 1.20m; dbContext.SaveChanges(); var productListAfterUpdate = dbContext.Products.ToList(); Console.WriteLine("=================================="); DisplayProductList(productListAfterUpdate); } }
private static void DeleteProductType() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var productTypeListBeforeDelete = dbContext.ProductTypes.ToList(); DisplayProductTypeList(productTypeListBeforeDelete); var deleteProductType = dbContext.ProductTypes .SingleOrDefault(p => p.Description == "Who Knocks"); if (deleteProductType == null) { return; } dbContext.ProductTypes.Remove(deleteProductType); dbContext.SaveChanges(); var productTypeListAfterDelete = dbContext.ProductTypes.ToList(); DisplayProductTypeList(productTypeListAfterDelete); } }
private static void TrackingEntities() { using (var dbContext = new CoffeeShopDbContext()) { dbContext.Database.Log = Console.WriteLine; var typeList = dbContext.ProductTypes.AsNoTracking().ToList(); foreach (var productType in typeList) { Console.WriteLine(productType.Description); } var productTypeModified = typeList[1]; productTypeModified.Description = "XXX"; dbContext.Entry(productTypeModified).State = EntityState.Modified; foreach (var entry in dbContext.ChangeTracker.Entries()) { Console.WriteLine("Entity Name: {0}", entry.Entity.GetType().FullName); Console.WriteLine("Status: {0}", entry.State); } } }