title: Can I join a table to a list using linq?
body: <p>I have a table as follows:</p>
  
  <pre><code>PersonalDetails
  
  Columns are:
  
  Name  
  BankName
  BranchName
  AccountNo
  Address
  </code></pre>
  
  <p>I have another list that contains 'Name' and 'AccountNo'.
  I have to find all the records from table that whose respective 'Name' and 'AccountNo' are present in given list. </p>
  
  <p>Any suggestion will be helpful.</p>
  
  <p>I have done following but not of much use:</p>
  
  <pre><code>var duplicationhecklist = dataAccessdup.MST_FarmerProfile
                            .Join(lstFarmerProfiles, 
                                  t =&gt; new { t.Name,t.AccountNo}, 
                                  t1 =&gt; new { t1.Name, t1.AccountNo}, 
                                  (t, t1) =&gt; new { t, t1 })
                             .Select(x =&gt; new {
                                                 x.t1.Name,
                                                 x.t1.BankName,
                                                 x.t1.BranchName,
                                                 x.t1.AccountNo
                                               }).ToList();
  </code></pre>
  
  <p>where <code>lstFarmerProfiles</code> is a list.</p>