如何将这个SQL查询Linq lambda表达式(暂停)How to convert this SQL query to Linq lambda expression [on hold]

- 此内容更新于:2015-01-06
主题:

这是我的SQL查询返回所需的结果,我想把这个SQL查询一个linq lambda表达式

原文:

This is my SQL query which is returning the desired result, and I want to convert this SQL query to a linq lambda expression

SELECT     
   [BlueBusDatabase].[dbo].[M_BLUEBUS_CITY].CITY_NAME,
   [BlueBusDatabase].[dbo].[M_BLUEBUS_CITY].PK_CITY_ID,
   [BlueBusDatabase].[dbo].[M_BLUBUS_INTER_CITY].CITY_SEQUENCE
FROM       
   [BlueBusDatabase].[dbo].[M_BLUEBUS_CITY]
INNER JOIN 
   [BlueBusDatabase].[dbo].[M_BLUBUS_INTER_CITY] ON [BlueBusDatabase].[dbo].[M_BLUEBUS_CITY].PK_CITY_ID = [BlueBusDatabase].  [dbo][M_BLUBUS_INTER_CITY].FK_INTER_CITY_ID
WHERE      
   [BlueBusDatabase].[dbo].[M_BLUBUS_INTER_CITY].FK_COMB_ID =1
ORDER BY   
   [BlueBusDatabase].[dbo].[M_BLUBUS_INTER_CITY].CITY_SEQUENCE
解决方案:
U Can refer呼吸学Link http://www.sqltolinq.com/ 然而 http://www.linqpad.net/
原文:

U Can refer following Link http://www.sqltolinq.com/
OR http://www.linqpad.net/