Linq2Sql How to write outer join query?

Posted by Malcolm on Stack Overflow See other posts from Stack Overflow or by Malcolm
Published on 2010-04-10T09:56:29Z Indexed on 2010/04/10 10:03 UTC
Read the original article Hit count: 230

Filed under:

Hi,

I have following SQL tables.

ImportantMessages

impID

Message

ImportantMessageUsers

imuID

imuUserID

imuImpID

I want to write a Linq2Sql query so that it returns any rows from ImportantMessages that does not have a record in ImportantMessagesUsers.

Matchiing fields are impID ----- imuImpID

Assume imuUserID of 6

© Stack Overflow or respective owner

Related posts about linq-to-sql