我正在尝试使用Linq查询来填充下拉列表。然而,我需要将名字和姓氏作为一个字段呈现。在DDL.DataTextField
中进行拼接会导致无法找到该字段的错误。
SQL语句大概是这样的:
SELECT (FirstName + SPACE + Surname) AS FullName FROM Table WHERE ID=1
当前的Linq:
public IList<mytable> GetNames(int p_ID)
{
return db.mytable.Where(c => c.ID_fk == p_ID).ToList();
}
(from c in db.mytable where c.ID_fk == p_ID select (c.FirstName + " " + c.Surname)).ToList()
,对吗? - Amedio