Conditional Join In LINQ?
Posted
by Soo
on Stack Overflow
See other posts from Stack Overflow
or by Soo
Published on 2010-06-01T15:16:53Z
Indexed on
2010/06/01
15:23 UTC
Read the original article
Hit count: 209
I am trying to write a query that grabs information from one database and joins it to information in a different database.
TableA
idA
valueA
idB
TableB
idB
valueB
The tricky part is that in TableA, idB isn't always defined, so when I do a normal join, I only get results where TableA has a idB value. What I want is to be able to grab all of the information from TableA even if it doesn't have a corresponding idB value.
© Stack Overflow or respective owner