title: How do you left join using "date between" operator in linq?
body: <p>I have two tables. The parent table has a single date column, and child table has 2 date columns (From / To). I need to make a left join from parent to child where parent's date column is between one in child. In sql this would look something like this:</p>
  
  <pre><code>select p.cob, count(*) from parent p
  left join child c on p.cob between c.effective and c.expiry
  group by p.cob
  </code></pre>
  
  <p>How does one write this in linq - I'm a bit stuck here....</p>