以下SQL的等效LINQ查询是什么? [英] what is the equivalent LINQ query for the SQL below?

问题描述

SELECT        0 AS GroupId, 'Select All' AS GroupName
UNION
SELECT        GroupId, GroupName
FROM            tbl_AccountGroup

推荐答案

尝试

ar infoQuery =
    (from c in tbl_AccountGroup
    select c.GroupId,c.GroupName)
    .Union
        (from c1 in tbl_AccountGroup
        select 0,''Select All'')
;

这篇关于以下SQL的等效LINQ查询是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！