private void RunLinqUsingQuerySyntax()
{
DataBaseUtilitiesExample dataBaseUtilitiesExample = new DataBaseUtilitiesExample(10);
Console.WriteLine("");
Console.WriteLine("LINQ using Query Syntax");
Console.WriteLine("----------------------");
var vendorsQuery = from v in dataBaseUtilitiesExample.ListOfVendors
where v.VendorID == 2
select v;
PrintCollection(vendorsQuery.ToList());
Console.WriteLine("");
Console.WriteLine("");
}
private void RunLinqUsingMethodSyntax()
{
DataBaseUtilitiesExample dataBaseUtilitiesExample = new DataBaseUtilitiesExample(10);
Console.WriteLine("");
Console.WriteLine("LINQ using Method Syntax");
Console.WriteLine("----------------------");
var vendorsQuery = dataBaseUtilitiesExample.ListOfVendors
.Where(v => v.VendorID == 7 || v.VendorID == 2)
.OrderByDescending(v => v.VendorName);
PrintCollection(vendorsQuery.ToList());
Console.WriteLine("");
Console.WriteLine("");
}
