private static void RawSelectProducts() // Выполнение "сырых" запросов на контексте
{
using (var dataContext = new NorthwindDataContext())
{
IEnumerable <Product> products = dataContext.ExecuteQuery <Product>("SELECT * FROM Products");
foreach (Product product in products)
{
Console.WriteLine("{0} | {1}", product.ProductID, product.ProductName);
}
}
}
/// <summary>
/// Talk Direct to SQL Server
/// </summary>
private void DirectExecution()
{
var dc = new NorthwindDataContext();
var usaCustomers = dc.ExecuteQuery <Customer>(@"SELECT CustomerID, CompanyName, City, Region
FROM Customers WHERE Country = 'USA' ");
"Customers in the USA".DisplayHeader();
foreach (var cust in usaCustomers)
{
string.Format("{0} in {1}, {2}", cust.CompanyName, cust.City, cust.Region).DisplayResults();
}
}
