• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

Need help converting T-SQL query into LINQ query

I need help converting the T-SQl query below into a LINQ query.   Can anyone help?
SELECT DISTINCT pa.AttributeId, a.Name, ap.Permission 
FROM ProductAttribute AS pa
JOIN attribute as a on pa.AttributeId = a.Id
LEFT JOIN AttributePermission AS ap ON a.Id = ap.AttributeId and ap.userId = @userId
ORDER BY pa.AttributeId

Open in new window

0
markerasmus
Asked:
markerasmus
  • 2
2 Solutions
 
mayank_joshiCommented:
0
 
markerasmusAuthor Commented:
Thanks, your solution helped.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now