C＃linq查询与groupby，有和哪里。 [英] C# linq query with groupby, having and where.

问题描述

Hi,

How to write Linq Query for below SQL Query.

Select Count(ul.OriginId),ul.OriginId from UserLink ul
Where ul.OriginId is not null
group by ul.OriginId
having count(ul.OriginId)>1


Select ul.UserId from UserLink ul where ul.OriginId=123

Finally I want to return UserId group by OriginId but here I have written in two separate queries. 
Can we write above sql queries in single Linq query? please help me how to write  linq query in C#.

Thanks,
jayaram

我尝试了什么：



我无法在Linq中使用。

What I have tried:

I am not able to use having in Linq.

推荐答案

取决于你在尝试什么实现...



尝试：

Depending on what you're trying to achieve...

Try:

var data = context.UserLink
    .GroupBy(x=>x.OriginId)
    .Where(grp=>grp.Key==123 && grp.Count()>1)
    .SelectMany(grp=>new
        {
             OriginId = grp.Key,
             UserId = grp.Select(u=> u.UserId)
             CountOfOriginId = grp.Count(),
         })
    .ToList();

最后，我建议：

1）dowload 101 Linq样本 [ ^ ]

2）下载 LinqPad [ ^ ]

这篇关于C＃linq查询与groupby，有和哪里。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！