sqlqury到linq查询 [英] sqlqury to linq query

问题描述

你好，

i我在我的代码后面使用sql查询文件，我是linq中的新手我只想将sql查询转换为linq

请给我linq查询我的sql查询。

提前感谢。

我的表名是Organization.TblOrganizationUnits，列是Unitname，OrganizationUnitId和ParentId

我的sqlquery是

hello,
i am using sql query on my code behind file,i am new in linq i just want to convert a sql query to linq
please give me the linq query for my sql query.
thanks in advance.
my table name is Organization.TblOrganizationUnits,and columns are Unitname,OrganizationUnitId,and ParentId
my sqlquery is

string query = string.Format(@"WITH Node (OrganizationUnitId, UnitName,ParentUnitId)
                               AS  (
                                   SELECT    Organization.TblOrganizationUnits.OrganizationUnitId, Organization.TblOrganizationUnits.UnitName , Organization.TblOrganizationUnits.ParentUnitId
                                   FROM       Organization.TblOrganizationUnits
                                   WHERE      OrganizationUnitId ={0}
                                   UNION ALL
                                   SELECT      Organization.TblOrganizationUnits.OrganizationUnitId,  Organization.TblOrganizationUnits.UnitName, Organization.TblOrganizationUnits.ParentUnitId
                                   FROM        Organization.TblOrganizationUnits
                                   INNER JOIN Node
                                   ON          Organization.TblOrganizationUnits.ParentUnitId = Node.OrganizationUnitId
                                   )
                               SELECT  OrganizationUnitId, UnitName,ParentUnitId FROM   Node
                               where  OrganizationUnitId not in (SELECT  ParentUnitId FROM   Node)
                              option (maxrecursion 0); ", OrganizationUnitId);

推荐答案

请先学习LINQ，然后尝试转换代码。



在这里，我们回答成员在编程时遇到的具体问题。



我们无法在整体上工作源代码。你需要自己做。

如果你在编码时遇到任何困难，请随时回到这里并提出另一个问题，说明具体问题。



各位会员很乐意为您提供帮助。



Happy Coding。：）

Please learn LINQ first, then try to convert you code.

Here we answer specific questions which members face during programming.

We can't work on the whole source code. You need to do that yourself.
If you face any difficulty while coding, feel free to come back here and ask another question with specific issue describing the scenario.

Members will be happy to help you then.

Happy Coding. :)

使用 LINQPad 等工具[ ^ ]

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