SQL到LINQ-转换 [英] SQL TO LINQ- Conversion

问题描述

如何将其转换为Linq?

How do I convert this into Linq?

    SELECT 
        ps.forename,Count(ps.Forename) 

FROM 
        [Dbase].[dbo].[Absence] ab
INNER JOIN
        [Dbase].[dbo].[Person] ps
On 
ab.empid=ps.id
where ps.forename='hari'
GROUP BY ps.forename
Having Count(ps.forename)>2

推荐答案

在这里.

            var result = (from x in Absence
                     join y in Person on x.empid equals ps.id
                     group x by new { z = ps.forename == "hari" } into g
                     where g.Count() > 2
                     select new
                     {
                         g.Key,
                         cnt = g.Count()
                     });

这篇关于SQL到LINQ-转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！