简单linq示例

DataContext ctx = new DataContext("Data Source=PC-201010161635//SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"); Table<Orders> order = ctx.GetTable<Orders>(); GridView1.DataSource = from c in order where c.CustomerID.StartsWith("A") select new {顾客ID=c.CustomerID,员工编号=c.EmployeeID, 订单编号=c.OrderID, 订单时间=c.OrderDate }; GridView1.DataBind();执行查询 更新: DataContext ctx = new DataContext("Data Source=PC-201010161635//SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"); //执行T-Sql 更新 ctx.ExecuteCommand("update Orders set OrderDate={0} where CustomerID like 'A%' ", DateTime.Now); //执行查询 IEnumerable<Orders> Orders = ctx.ExecuteQuery<Orders>("select * from Orders where CustomerID like 'A%'"); GridView1.DataSource = Orders; GridView1.DataBind();