title: LINQ-To-Entity (The specified type member '' is not supported in LINQ to Entities)
body: <p>I am having difficulty understanding this problem:</p>
  
  <p>Here is the T-SQL query I need to implement using LINQ to Entities</p>
  
  <pre><code>select r.ReviewID, b.BusinessID, b.Name as BusinessName ,r.Description
  from gb_business.Review r
  inner join gb_business.Business b on r.BusinessID = b.BusinessID
  inner join gb_listing.RegionalService rs on b.BusinessID = rs.BusinessID
  where r.ReviewStatusID=1 and rs.TypeID=1 and rs.IsMain=1
  </code></pre>
  
  <p>In VS2010 it looks like this (without the <strong>where</strong> clause)</p>
  
  <pre><code>var res1 = (from r in context.Review
              join b in context.Business on r.BusinessID equals b.BusinessID
              join rs in context.RegionalService on b.BusinessID equals rs.Business.BusinessID
              select r).ToList();
  </code></pre>
  
  <p>This expression compiles well but at run time there is an exception: The specified type member 'BusinessID' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.</p>
  
  <p>I am wondering why BusinessID is a problem. Thank you.</p>