static void queryingCategories() { using (var db = new northwind()){ var loggerFactory = db.GetService <ILoggerFactory>(); loggerFactory.AddProvider(new ConsoleLoggerProvider()); Console.WriteLine("Categories and how many products they have:"); // a query to get all categories and their related products IQueryable <category> cats = db.categories .Include(c => c.products); foreach (category c in cats) { Console.WriteLine($"{c.categoryName} has {c.products.Count} products."); } } }
static void queryingLike() { using (var db = new northwind()){ var loggerFactory = db.GetService <ILoggerFactory>(); loggerFactory.AddProvider(new ConsoleLoggerProvider()); Console.WriteLine("Enter part of a product name: "); string input = Console.ReadLine(); IQueryable <product> prods = db.products .Where(p => EF.Functions.Like(p.ProductName, $"%{input}")); foreach (product item in prods) { Console.WriteLine("{0} has {1} units in stock. Discontinued? {2}", item.ProductName, item.stock, item.discontinued); } } }