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