读书人

linq多ID查询这句话查询语句应该如何

发布时间: 2014-01-13 17:16:02 作者: rapoo

linq多ID查询,这句话查询语句应该怎么写?


IQueryable<NewsInfo> queryable = (from c in this.db.NewsInfo
where c.SmallId == 9 //这里我要查询:9,10,11,12,13多个ID,怎么写? orderby c.id descending
select c).Take<NewsInfo>(itop);


where c.SmallId == 9 //这里我要查询:9,10,11,12,13多个ID,怎么写?
[解决办法]
定义一个id数组,判断 数组.Contans(c.SmallId)
[解决办法]
IQueryable<NewsInfo> queryable = (from c in this.db.NewsInfo
where "9,10,11,12,13".Split(',').Contains(c.SmallId) orderby c.id descending
select c).Take<NewsInfo>(itop);
.

参考:http://blog.csdn.net/q107770540/article/details/5387946
[解决办法]

IQueryable<NewsInfo> queryable = (from c in this.db.NewsInfo
where new int[] { 9,10,11,12,13 }.Contains(dt.Field<Int32>("SmallId "))
orderby c.id descending
select c).Take<NewsInfo>(itop);

[解决办法]

IQueryable<NewsInfo> queryable = this.db.NewsInfo.Where(c => new int[] { 9, 10, 11, 12, 13 }.Contains(c.SmallId)).Take<NewsInfo>(itop);

读书人网 >.NET

热点推荐