我有一个面包屑表,我想返回最近插入的行。在 SQL 中它将是MAX()
函数,但不确定如何在 LINQ 中执行等效操作。基本上我想选择具有最高的行BreadCrumbID WHERE ProjectID = 49
.
这是我现在的查询,它将选择所有行WHERE ProjectID = 49
。我想选择具有最高的行BreadCrumbID
.
Thanks!
Code:
using (dbPSREntities5 myEntities = new dbPSREntities5())
{
var currentStatus = (from tbBreadCrumb in myEntities.tbBreadCrumbs.Where(x => x.ProjectID == 49)
select new
{
Status = tbBreadCrumb.BreadCrumbID,
});
}
尝试这个:
using (dbPSREntities5 myEntities = new dbPSREntities5())
{
var currentStatus = (from tbBreadCrumb in myEntities.tbBreadCrumbs.Where(x => x.ProjectID == myEntities.tbBreadCrumbs.Max(b=>b.ProjectId))
select new
{
Status = tbBreadCrumb.BreadCrumbID,
});
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)