title: Adding a second query inside the SELECT of a LINQ to Entities query gives Not Recognized Method error
body: <p>I have built a LINQ query for to fill one of my <code>ViewModel</code> with data but inside the <code>.SELECT()</code> method I tried to add another query to populate one of the VM's properties. When I ran the page I got the error:</p>
  
  <blockquote>
    <p>LINQ to Entities does not recognize the method 'System.Linq.IQueryable<code>1[FFInfo.DAL.Location] Include[Location](System.Linq.IQueryable</code>1[FFInfo.DAL.Location], System.String)' method, and this method cannot be translated into a store expression.</p>
  </blockquote>
  
  <p>The reason I am using the second query is because <code>LocationTransitionPoints</code> does link directly to <code>Locations</code> (via <code>ToLoation</code> and <code>FromLocation</code>) but it does not link directly to <code>Section</code> and I don't know how to work my way up to it (LocationTranitionPoints -> Locations -> Section)</p>
  
  <p>I have a felling I am just missing some stupid little thing but can't place my finger on it, any suggestions please?</p>
  
  <pre><code>        public ActionResult TransitionPoints()
      {
          try
          {
              using (var db = new GeographyContext())
              {
                  var model = db.LocationTransitionPoints
                                .Include("FromLocation")
                                .Include("ToLocation")
                                .Select(ltp =&gt; new TransitionPointsVM()
                                {
                                    FromLocation = ltp.FromLocation.Name,
                                    ID = ltp.ID,
                                    SectionTitle = db.Locations.Where(l =&gt; l.ID == ltp.ToLocationID).Include("Section").Select(l =&gt; l.Section.Title).First(),
                                    ToLocation = ltp.ToLocation.Name,
                                    TransitionPoint = ltp.TransitionPoint
                                }).ToList();
  
                  return View(model);
              }
          }
          catch (Exception ex)
          {
              ErrorSignal.FromCurrentContext().Raise(ex);
              return PartialView("LoadError");
          }
      }
  </code></pre>