DataContext 连接

DataContext dataContext = newDataContext(@"Data Source = .\instance1;Initial Catalog=master; Integrated Security= true"); 

Table<Customer> customers = dataContext.GetTable<Customer>(); 

IQueryable<string> query = customers.Where(n => n.Name.Contains(“a"))

                                       .OrderBy(n => n.Name.Length)

                                       .Select(n => n.Name.ToUpper());

转载于:https://www.cnblogs.com/meizi3204/archive/2011/11/23/2260425.html