20/04/2012, 13:40
|
| | | Fecha de Ingreso: mayo-2011
Mensajes: 105
Antigüedad: 13 años Puntos: 3 | |
 Subconsultas en linq to sql
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]? |