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);
}
}
}
