public static void ShowSalesByRegionAndPeriod(string shipRegion, DateTime startDate, DateTime endDate)
{
using (var db = new NorthwindDB.NorthwindEntities())
{
var orders = db.Orders
.Where(o => o.ShipRegion == shipRegion &&
o.OrderDate >= startDate &&
o.OrderDate <= endDate)
.Select(o => o.OrderID + " " + o.OrderDate + " " + o.ShipRegion);
foreach (var order in orders)
{
Console.WriteLine(order);
}
}
}
public static void ShowCustomerByOrderDateAndShippingCountryNativeSql(int year, string country)
{
string query = String.Format(@"
SELECT CONCAT(c.CompanyName, ' ', o.OrderDate, ' ', o.ShipCountry, o.OrderID)
FROM dbo.Orders o
INNER JOIN dbo.Customers c
ON o.CustomerID = c.CustomerID
WHERE YEAR(o.OrderDate) = {0} AND o.ShipCountry = '{1}'",
year, country);
using (var db = new NorthwindDB.NorthwindEntities())
{
var queryResult = db.Database.SqlQuery <string>(query).ToList();
foreach (var foundResult in queryResult)
{
Console.WriteLine(foundResult);
}
}
}
