需要帮助以子查询将SQL转换为LINQ [英] Need help to Convert SQL with subquery into LINQ

问题描述

我想知道如何在LINQ中编写这种SQL(子查询).
ps.我对LINQ>非常陌生.

I wonder how to write this kind of SQL(subquery) in LINQ.
ps. I''m very new to LINQ >.<"

select  adv.[Advertise_ID],
(select [ProjectDB].[dbo].[Categories].Name
 from [ProjectDB].[dbo].[Categories]
 where adv.Advertise_Category_ID1 = [ProjectDB].[dbo].[Categories].id) as Cat_Name1,
(select [ProjectDB].[dbo].[Categories].Name
 from [ProjectDB].[dbo].[Categories]
 where adv.Advertise_Category_ID2 = [ProjectDB].[dbo].[Categories].id) as Cat_Name1
from [ProjectDB].[dbo].[Advertisements] adv

推荐答案

AFAIK yo无法将SQL子查询直接转换为LINQ.但是您可以使用任何操作: http://msdn.microsoft.com/en-us/library/bb337697.aspx [ ^ ].

有关示例，请参见: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b [ ^ ]

AFAIK yo cannot directly convert SQL subqueries to LINQ. But you can use perhaps Any operation: http://msdn.microsoft.com/en-us/library/bb337697.aspx[^].

For examples, see: http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b[^]

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