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