1.一对多关系查询:
var q=from c in db.Students
from n in c.orders
where c.City=='wuhan'
select n;
2.多对多关系查询:
var q=from e in db.Students
from et in e.name
where e.city=='wuhan'
select new
{
e.firstName,
e.lastName
}
3.where 简单形式查询
var q=from c in db.students
where c.city=="hhh"
select c;
条件筛选:
var q=from c in db.students
where c.sex>=5
select c;
4.first(实质就是sql中top1)
简单用法:选择表中的第一个发货方。
Shipper shipper = db.Shippers.First();
选择CustomerID 为“BONAP”的单个客户
Customer cust = db.Customers.First(c => c.CustomerID == "BONAP");
5.匿名函数:
var q =
from c in db.Customers
select new {c.ContactName, c.Phone};
使用 SELECT 和匿名类型返回仅含客户联系人姓名和电话号码的序列;
6.where 和order by形式:
var q =
from o in db.Orders
where o.ShipCity == "London"
orderby o.Freight
select o;
7.Concat(连接)简单形式:
返回所有消费者和雇员的电话和传真
var q = (
from c in db.Customers
select c.Phone
).Concat(
from c in db.Customers
select c.Fax
).Concat(
from e in db.Employees
select e.HomePhone
);
Union(合并)
8.插入(Insert)::::
NorthwindDataContext db = new NorthwindDataContext();
var newCustomer = new Customer
{
CustomerID = "MCSFT",
CompanyName = "Microsoft",
ContactName = "John Doe",
ContactTitle = "Sales Manager",
Address = "1 Microsoft Way",
City = "Redmond",
Region = "WA",
PostalCode = "98052",
Country = "USA",
Phone = "(425) 555-1234",
Fax = null
};
db.Customers.InsertOnSubmit(newCustomer);
db.SubmitChanges();
9.更新update::::
Customer cust =db.Customers.First(c => c.CustomerID == "ALFKI");
cust.ContactTitle = "Vice President";
db.SubmitChanges();
10.删除delete::::::
OrderDetail orderDetail =
db.OrderDetails.First(c => c.OrderID == 10255 && c.ProductID == 36);
db.OrderDetails.DeleteOnSubmit(orderDetail);
db.SubmitChanges();
Linq语法
最新推荐文章于 2024-06-27 16:20:55 发布