LINQ: How to write queries with complex join conditions

added by mehroz
4/13/2010 11:11:01 AM


This small post is a follow-up of my previous post in which I discussed some common scenarios and how we can handle them in our LINQ queries. This time, we will see how to write queries that have not-so-simple conditions as join predicates. Note that LINQ directly supports only equi-joins, that is, joins based on equal conditions. Let's look how to handle joins having other conditions such as between, etc.