我如何做一个子选择在LINQ

本文关键字：选择 LINQ 何做一 | 更新日期: 2023-09-27 18:09:10

我是SQL server的新手，请任何人帮助我如何在LINQ中编写这个查询。

 SELECT [Plan_Num]
      ,(select top 1 ba_level_code + ' - ' + ba_level_desc from baLevel where ba_level_code = '0' + Level_Num) as [Level]
      ,(select top 1 cast(Column_Num as varchar) + ' - ' + Column_Description from baPlanColumnStructure where Column_Num = CL.Column_Num) as [Column]
      ,[Sort_Order]
  FROM baCodeLibrary CL where code_id = 25468 and isactive = 1 order by [Plan_num]

谢谢

我如何做一个子选择在LINQ

您正在寻找这样的内容

var query = from cl in context.BaCodeLibrary
            where cl.code_id == 25468 && cl.isactive == 1
            orderby cl.Plan_num
            select new
            {
              Level = (from ba in context.baLevel
                       where ba.ba_level_code == ("0" + ba.Level_Num)
                       select ba.ba_level_code + " - " + ba.ba_level_desc).Take(1),
              Column = (from ba in context.baPlanColumnStructure 
                        where ba.Column_Num == cl.Column_Num
                        select ba.ba_level_code + " - " + ba.ba_level_desc).Take(1),
               Sort_Order = cl.Sort_Order
            }