Tengo esta consulta en sql
SELECT MM.ID, MM.[Content],
(SELECT C.FullName
FROM ClientMessages AS CM INNER JOIN
Clients AS C ON CM.IDClient = C.ID
WHERE (CM.IDMessage = MM.ID) AND (CM.Owner = 1)) AS Creator
FROM MessageModels AS MM INNER JOIN
ClientMessages AS MCM ON MCM.IDMessage = MM.ID INNER JOIN
Clients AS MC ON MCM.IDClient = MC.ID
WHERE (MC.ID = 1)
como la traduzco a linq? especial la[COLOR="rgb(255, 140, 0)"] subconsulta[/COLOR]?