title: Joining Collections and Assigning values
body: <p>I have two collections and i want to join them based on key attribute and assign one collection's values to other. I am doing it in following way </p>
  
  <pre><code>var joinedData =   from collection_one in Office.Employees 
                 join collection_two in NewOffice.Employees 
                    on collection_1.OfficeId equals collection_two.OfficeId
                 select new { collection_one, collection_two};
  
  
  // Declare a new Collection 
  
  ICollection&lt;Office.Employees&gt; updatedCollection = New List&lt;Office.Employees&gt;();
  
  // Assign New Collection_Two Values to Collection_One
  foreach (var item in joinedData.ToList())
              {
                  item.collection_one.Deleted = item.collection_two.Deleted;
                  updatedCollection .Add(item.obp);
              }
  </code></pre>
  
  <p>this is not producing the right result. My Join is producing more records than it should for an inner join. Can anyone spot an issue ?</p>