8,497
社区成员
发帖
与我相关
我的任务
分享
select TName
from routes
where SName in('天津','石家庄')
group by TName
having count(SName)>1
IQueryable<T> Filter(Expression<Func<T, bool>> predicate, params Expression<Func<T, object>>[] includes);
. var result =
userRepository.Filter(e => e.SName.Contains("天津") || e.SName.Contains("石家庄"))
.GroupBy(e => e.TName)
.Where(g=>g.Count(SName)) > 1);
var query = from r in rounts
where ("天津,石家庄").Split(",").Any(a => r.sname = a)
group r by r.tname into r_grp
where r_grp.Count() > 1
select new { tname = r_grp.key };
routes.Where(s => list.Contains(s.SName)).GroupBy(c => c.TName).Where(g => g.Count() > 1);
routes.Where(s => list.Contains(s.SName)).GroupBy(c => c.TName).Where(g => g.Count() > 1).Select(g => g.Key);
这样是返回的TName列表