title: Cannot implicitly convert type ‘System.Linq.IQueryable<AnonymousType#1>’ to ‘System.Collections.Generic.IEnumerable<SubCateViewModel>’
body: <p>I got this problem when I'm trying join three tables <code>ProductPhoto</code>, <code>Product</code>, and <code>ProductProductPhoto</code>. I tried many case but it didn't work out. Anyone could help me get out of this? Thanks for replying!</p>
  
  <pre><code>private IEnumerable&lt;SubCateViewModel&gt; GetSubProduct()
              {
                  var context = new AdvenDBEntities();
                  var subcate = (from a in context.ProductPhotoes
                                join b in context.ProductProductPhotoes on a.ProductPhotoID equals b.ProductPhotoID
                                join c in context.Products on b.ProductID equals c.ProductID
                                join d in context.ProductSubcategories on c.ProductSubcategoryID equals d.ProductSubcategoryID
                                select new
                                {
                                    a.ProductPhotoID,
                                    a.ThumbnailPhotoFileName,
                                    c.ProductID,
                                    c.Name,
                                    d.NameofBike,
                                    d.isSelected,
                                }).AsQueryable();
                           return subcate;
              }
  </code></pre>