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