title: LINQ Join On Between Clause
body: <p>I am having some issues throwing together a LINQ query that will join a table based on a zip code.  I need to join the table based on whether the customer's zip code lies with in a range of zip codes that is determined by ZIPBEG and ZIPEND columns.</p>
  
  <p>The T-SQL would look something like this: </p>
  
  <pre><code>JOIN [ZipCodeTable] [zips] 
      ON [customer].[zipcode] BETWEEN [zips].[ZIPBEG] AND [zips].[ZIPEND]
  
  -- or
  
  JOIN [ZipCodeTable] [zips] 
      ON [zips].[ZIPBEG] &lt;= [customer].[zipcode] 
          AND [zips].[ZIPEND] &gt;= [customer].[zipcode]
  </code></pre>