(linq)这句用lambda表达式怎么写
- C# code
// select * from tb where id in (select min(id) as id from tb group by pdt_id )WeblogContext db = new WeblogContext();IEnumerable<Article> Articles = db.Articles. ??????????
后面咋写??
[解决办法]
db.Articles.Select(v=>xxxxxxxx)
[解决办法]
select * from tb where id in (select min(id) as id from tb group by pdt_id )
var result = db.Articles.GroupBy(x => x.pdt_id).Select(x => x.OrderBy(y => y.id).First());