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

Filed under:
|
|

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

Related posts about c#

Related posts about LINQ