private static ICollection<string> SelectOrdersByRegionAndDate(string region, DateTime start, DateTime end)
{
using (var baseConn = new NorthwindEntities())
{
var result = baseConn.Orders.Where(
x => x.ShipRegion == region && x.OrderDate >= start && x.OrderDate <= end).Select(
c => c.Customer.CompanyName + " " + c.ShipAddress + " " + c.ShipCountry).ToList();
return result;
}
}
public static void Main()
{
using (var baseConn = new NorthwindEntities())
{
var customers = baseConn.Customers.Where(x => x.Orders.Where(o => o.OrderDate.Value.Year == 1997 && o.ShipCountry == "Canada").Any());
foreach (var item in customers)
{
Console.WriteLine(item.CustomerID);
}
}
}
public static void Main()
{
using (var baseConn = new NorthwindEntities())
{
var customers = baseConn.Database.SqlQuery<string>(@"SELECT DISTINCT c.CustomerID
FROM Customers c JOIN Orders o
ON c.CustomerID = o.CustomerID
WHERE o.ShipCountry ='Canada' AND o.OrderDate like '%1997%'");
foreach (var item in customers)
{
Console.WriteLine(item);
}
}
}
