title: Linq select all numbers that are in any interval from another list of intervals
body: <p>I am trying write linq lambda select to get all records from database that has a number which is in any of the specific intervals from other list or database table. Lets say i have a table "SOURCE"
  <code>
  +------+------+-------+------+------+
  | Col1 | Col2 | reqNr | col5 | col6 |
  +------+------+-------+------+------+
  | x    | x    |     9 | x    | x    |
  | x    | x    |    14 | x    | x    |
  | x    | x    |    19 | x    | x    |
  | x    | x    |    24 | x    | x    |
  +------+------+-------+------+------+
  </code>
  and I have already selected table "INTERVALS"
  <code>
  +------+----+
  | from | to |
  +------+----+
  |    1 |  3 |
  |    5 | 10 |
  |   15 | 30 |
  +------+----+
  </code> 
  to object list "intervalList" in c#. 
  How can write ".Where()" part in linq sql statement to get all records from "SOURCE" that has "ReqNr" column value which falls in any of the intervals from "intervalList" list.
  For example: <code>.where(w =&gt; intervalList.any(w.ReqNr &gt; intervalList.from &amp;&amp; w.ReqNr &lt; intervalList.to))</code></p>