我试图在LINQ to Entities中编写以下SQL查询,我该怎么做?
SELECT codigo FROM Vendas ORDER BY codigo DESC LIMIT 1;
我知道如何使用DESC
,但LIMIT 1
呢。我可以用我所知道的东西编写这种代码,但如果表Vendas
:上有多行,它显然会抛出异常
using (TccContext db = new TccContext())
{
var query = (from venda in db.Vendas
orderby venda.codigo descending // `LIMIT 1` in LINQ should be added here I think
select venda).SingleOrDefault();
}
提前谢谢。
using (TccContext db = new TccContext())
{
var query = (from venda in db.Vendas
orderby venda.codigo descending
select venda).FirstOrDefault();
}
如果您需要具有一个元素的Enumerable(实际上类似于SQL limit
):
using (TccContext db = new TccContext())
{
var query = (from venda in db.Vendas
orderby venda.codigo descending
select venda).Take(1);
}