SQL语句在MVC+EF中的表达

[拾光师]

select TName
from routes
where SName in('天津','石家庄')
group by TName
having count(SName)>1

在MVC+EF中怎么写呀，用LINQ和lambda都行

[拾光师]

这出来的是个什么类型呀，怎么用不了呀，怎么强制转换都没用

[巴士上的邂逅]

routes.Where(s => list.Contains(s.SName)).GroupBy(c => c.TName).Where(g => g.Count() > 1).Select(g => g.Key);

这样是返回的TName列表

[巴士上的邂逅]

试试

routes.Where(s => list.Contains(s.SName)).GroupBy(c => c.TName).Where(g => g.Count() > 1);

[拾光师]

那个SName in（‘天津','石家庄'）呢

[巴士上的邂逅]

引用 2 楼 Lxn2zh 的回复:

那个SName in（‘天津','石家庄'）呢

.Where(s => list.Contains(s.SName))

[cxmcxm]

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 };

[Fateljh]

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