我正在调用以下查询,以仅显示字段“UploadDate”的最新日期,但我遇到了异常错误,例如:
代码:无法在LINQ to Entities查询中构造实体或复杂类型'cdwModel.database_BD'。","ExceptionType":"System.NotSupportedException","StackTrace":
public IEnumerable<database_BD> GetDate()
{
var data = (from c in db.database_BD
select new database_BD()
{
UploadDate = c.UploadDate
}).ToList().OrderByDescending(c => c.UploadDate).Take(1);
return data;
}
数据库_业务数据模型类:
public partial class database_BD
{
public Nullable<System.DateTime> UploadDate { get; set; }
}
解决方案:
public DateTime? GetDate()
{
return data = db.database_BD.Select(d => d.UploadDate)
.OrderByDescending(c => c)
.FirstOrDefault();
}