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