title: Specified type member is not supported in linq to entities
body: <p>Hi hope someone can help.</p>
  
  <p>I have an EF4 context with 2 POCO based entities that map on to 2 tables in a legacy SQL2005 database.  There are no relationships betwen the tables and no associations between the entity definitions in the context.</p>
  
  <pre><code>public class Venue
  {
      public Venue(){}
      public string LocationCode {get;set;}
      public string LocationName {get;set;}
  }
  
  public class Booking
  {
      public Booking(){}
      public string LocationCode {get;set;}
      public int EventReference {get;set;}
      public Venue BookingVenue {get;set;}
      public Event BookingEvent {get;set;}
  }
  
  public class Event
  {
      public Event(){}
      public int EventReference {get;set;}
      public DateTime EventStart {get;set;}
      /* plus another 60 or so properties */
  }
  </code></pre>
  
  <p>I can do a LINQ select from each individually but whenever I try and join between Event and Booking I get </p>
  
  <p>The specified type member ‘BookingEvent’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.</p>
  
  <p>I've tried all the workarounds I can find across the web (there are no enums, calcualted properties, etc) and I'm more than a little frustrated now.</p>
  
  <p>Help ?
  Here's the query in question....</p>
  
  <pre><code>List&lt;Booking&gt; bookings = (from b in CalendarDB.Bookings
      join e in CalendarDB.Events join b.EventReference on e.EventReference
      select b).ToList();
  </code></pre>