title: C# linq lambda join and select syntax
body: <p>I'm looking for the counterpart of Msql query:</p>
  
  <pre><code>SELECT per.*,add.addressDescription FROM Persons per 
         JOIN Address add ON per.AddressId = add.AddressId
  </code></pre>
  
  <p>I have this query:</p>
  
  <pre><code>    var query = persons.JOIN(address,per = person.addressId,add = addressId
      (per,add) =&gt; 
      new Persons{
                  addressDescription = add.addressDescription,
                  PersonId = per.PersonId,
                  PersonFirstName = per.PersonFirstName
                  PersonLastName = per.PersonLastName})
  </code></pre>
  
  <p>Is there a way to populate <code>Persons.addressDescription</code> without assigning individually the other properties of <code>Persons</code>? Imagine if <code>Persons</code> have 10 more properties. </p>
  
  <p>I would like to refrain from using loops like:</p>
  
  <pre><code>foreach(Person person in PersonList)
  {
    foreach(Address address in AddressList)
    {
       if(person.addressId == address.addressId){
          person.addressDescription = address.addressDescription
       }
     }
  }
  </code></pre>