static async Task RunAsync() { using (ContosoContext context = new ContosoContext()) { var creator = context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator; await creator.ExistsAsync(); Console.WriteLine("Connection Succesfull"); await new ProductAndCategoryQuery().RunLogic(context); } }
public void RunLogic(ContosoContext context) { IEnumerable <Product> products = from product in context.Products where product.SafetyReviewResult ?? false select product; foreach (Product product in products) { Console.WriteLine($"[{product.ProductNumber}]\t{product.Name,35}\tPassed Review: {product.SafetyReviewResult}"); } }
public async Task RunLogic(ContosoContext context) { IEnumerable <Product> products = context.Products. Include(p => p.ProductCategory). Where(p => p.ListPrice <1450m && p.ListPrice> 1250m). Take(20); foreach (Product product in products) { Console.WriteLine($"[{product.ProductCategory.Name}]\t{product.Name,35}\t{product.ListPrice:C}"); } }