title: Joining a CSV file to query results
body: <p>I have a linq query written to read in a <code>.csv</code> file:</p>
  
  <pre><code>var csv =
      from line in File.ReadAllLines("C:/file.csv")
      let customerRecord = line.Split(',')
      select new Customer()
          {
              contactID = customerRecord[0],
              surveyDate = customerRecord[1],
              project = customerRecord[2],
              projectCode = customerRecord[3]
          };
  </code></pre>
  
  <p>From here, I'd like to inner join this data on <code>contactID</code> to another query:</p>
  
  <pre><code>var prods = 
      from prd in products
      join con in contacts
      on prd.PrimaryContact equals con.ContactID
      select new {createdDate = prd.CreatedDate, contactID = con.ContactID};
  </code></pre>
  
  <p>I'm new to linq, and would like to know how I can join the data from csv to prods on the contactID field.</p>
  
  <p>Thank you for your help in advance, it's much appreciated.</p>