我有以下的SQL查询:
SELECT C.ID, C.Name FROM Category C JOIN Layout L ON C.ID = L.CategoryID
JOIN Position P ON L.PositionID LIKE '%' + CAST(P.ID AS VARCHAR) + '%'
WHERE P.Code = 'TopMenu'
and following data
Position:
ID Code
1 TopMenu
2 BottomMenu
类别
ID Name
1 Home
2 Contact
3 About
布局
ID CategoryID PositionID
1 1 1
2 2 1,2
3 3 1,2
有了以上数据,是否可以将SQL查询转换为LINQ或Lambda表达式?
非常感谢您的帮助!