title: Cannot implicitly convert type 'System.Linq.IQueryable<Anon>to 'System.Linq.IQueryable<Report>An explicit conversion exists,are you missing a cast?
body: <p>How to select specific column from the table? I try this Shows error 
  Cannot implicitly convert type 'System.Linq.IQueryable' to 'System.Linq.IQueryable'. An explicit conversion exists,are you missing a cast? </p>
  
  <pre><code>var query = myRepository.Query().AsQueryable();
  
  query = query.Select(f =&gt;
                          new
                          {
                              f.Name,
                              f.Email,
                              f.Message,
                              f.Succeeded,
                              f.ExecutedOn,
                              f.CreatedOn,
                              f.DeletedOn
                          }).Where(file =&gt; file.DeletedOn == null).OrderByDescending(f =&gt; f.CreatedOn);
  
  return query.ToList();
  </code></pre>
  
  <p>but when i try this it works,</p>
  
  <pre><code>if (!String.IsNullOrEmpty(searchModel.Name))
            {
                query = query.Where(f =&gt;f.Name.Contains(searchModel.Name));
            }
   query = query.Where(file =&gt; file.DeletedOn == null).OrderByDescending(file =&gt; file.CreatedOn); 
  </code></pre>