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
linq-to-sql
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