Question

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

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

Answer 1

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

Answer 2

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

s = query.FirstOrDefault();

Answer 3

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

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