c# - 带别名的 Linq

Question

我在 C# 中有以下行:

var name = (from x in db.authors
                    where fullName == "Jean Paul Olvera"
                    orderby x.surname
                    select new { x.id_author, fullName= String.Concat(x.name," ", x.surname) });

我的问题是我想在我的 where 子句中使用别名，但我不能，'fullName' 显示为未声明。

Answer 1

您可以使用 let 来创建中间值:

var name = (from x in db.authors
            let fullName = x.name + " " + x.surname
            where fullName == "Jean Paul Olvera"
            orderby x.surname
            select new { x.id_author, fullName });