linq to sql 中从多条数据中查询1条数据如：select top(1) * from s where TypeID=1 order by ID desc

linq怎么写才能达到sql这种效果

2024-12-16 10:14:32

推荐回答（3个）

回答1：

db.S.Where(q=>q.TypeID==1).OrderByDesending(q=>q.ID).Take(1);

回答2：

var query =
from data in contex.s
orderby data.ID descending
where data.TypeID == 1

s = query.FirstOrDefault();

回答3：

var result =
(from r in s
where s.TypeID == 1

orderby s.ID descending
select r).FirstOrDefault();

最新问答

linq to sql 中从多条数据中查询1条数据 如：select top(1) * from s where TypeID=1 order by ID desc