c# - 无法隐式转换类型泛型列表的错误

Question

我有一堂课。

 public partial class RecentlyViewedReport
  {
    public int Id { get; set; }
    public string Email { get; set; }
    public int ReportId { get; set; }
    public DateTime DateTime { get; set; }

    public virtual Report Report { get; set; }
}

我有一种从 sql 表中检索数据的方法。

        public List<RecentlyViewedReport> GetRecentlyViewedReports(string userEmailId)
    {
        var result = (from pd in _context.RecentlyViewedReports
                 join od in _context.Reports on pd.ReportId equals od.Id
                 orderby pd.DateTime descending
                 select 
                 new
                 {
                     Id= pd.Id,
                     Email= pd.Email,
                     ReportId=pd.ReportId,
                     DateTime=pd.DateTime,
                     Report= od as Report //This lines giving me error
                 }).ToList();

        return result;
    }

检索报告数据的正确方法是什么

标签： c#.netlinqasp.net-web-api

Answer 1

尝试这个...

 var result = _context.RecentlyViewedReports.Include(c => c.Report)
                       .OrderByDescending(c => c.DateTime)
                       .Select(c => new
                         {
                           Id = c.Id,
                           Email = c.Email,
                           ReportId = c.ReportId,
                           DateTime = c.DateTime,
                           Report = c.Report
                         }).ToList();