title: How can a LINQ join select only the first record?
body: <p>I wish to select only the <strong>first record</strong> from the '<code>CustomerSubOwners</code>' table in join query below and wondered what was the best way to achieve this in LINQ.</p>
  
  <pre><code>var result= (from t1 in db.Cases
               from t2 in db.CustomerSubOwners
                            .Where(o =&gt; t1.CustomerId == o.CustomerId &amp;&amp; o.Expiry &gt;= DateTime.Now)
                            .DefaultIfEmpty()
               select t1);
  </code></pre>