title: Translate 'The member' to SQL so it doesnt throw the 'has no supported translation to SQL'
body: <p>I have been upgrading my database recently and got this error</p>
  
  <p>Basically what I have done is the following:</p>
  
  <p>I had a <code>Participants</code> table, which have a <code>Name</code>, <code>First Name</code>, <code>E-mail address</code>, ...
  Now I have refactored this to a <code>Persons</code> table and a <code>Participants</code> table. Each <code>participant</code> is linked to a <code>person</code> via an UUID.
  I have removed the <code>Name</code> and <code>First Name</code> from the <code>participants</code> table and they are now in the <code>Persons</code> table.</p>
  
  <p>In my Participants Partial Class:</p>
  
  <pre><code>public partial class Participant {
      public string Name {
          get {
              return this.Person.Name;
          }
      }
  
      public string FirstName {
          get {
              return this.Person.FirstName;
          }
      }
  </code></pre>
  
  <p>}</p>
  
  <p>So now my whole project can still find the name, and I don't have to edit lots of code at once.</p>
  
  <p>However the following query got me into trouble:</p>
  
  <pre><code>      _db.Participants.Where(q =&gt; whatever).OrderBy(q =&gt; q.Name).ThenBy(q =&gt; q.FirstName).ToList();
  </code></pre>
  
  <p>This throws the infamous <code>The member 'xxx.Models.Participants.Name' has no supported translation to SQL</code></p>
  
  <p>Is there a way to simply tell the SQL generator that <code>Participants.Name</code> is actually <code>Participants.Person.Name</code> ?</p>