Hi Guys,

I just wanna ask for your guidance on how to convert this SQL Query to a Linq Query, please see query below.

SELECT C.CaseNumber, C.OffenseDegree,
      (SELECT B.OffenseCategory + ','
         FROM CaseViolation AS A
        INNER JOIN OffenseType AS B
           ON A.OffenseType = B.OffenseId
        WHERE A.CaseNumber = C.CaseNumber
        FOR XML PATH ('')) AS OffenseName,
       C.C_EmployeeName, C.C_DateReceived, STATUS
  FROM CaseMaster AS C
Thank you