与case语句的查询从SQL Server到Linq查询C＃ [英] Query with case statement from SQL Server to Linq query c#

问题描述

我在SQL Server中下面的查询

I have the following query in sql server

    select COUNT(mc_owner) as nbr ,
    case mc_owner when 'Element1' then 'Element1' else 'others' end Owner 
    from [dbo].[full] 
    where (date_reception > '01-01-2015')
    group by (CASE mc_owner WHEN 'Element1' THEN 'Element1' ELSE 'others' END)
    order by nbr desc

我需要将其转换成的EntityFramework LINQ查询

I need to convert it to entityframework linq query

推荐答案

试试这个，

var result = fulltableData.Where(x=>x.date_reception > '01-01-2015')
            .GroupBy(x=> x.mc_owner.Equals("Element1")?"Element1":"others")
            .Select(x=> new{ nbr = x.Count(), Owner = x.Key})
            .OrderByDescending(x=>x.nbr);

这篇关于与case语句的查询从SQL Server到Linq查询C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！