c# - 如何从 LINQ to Entities 获取唯一值？

Question

我有一个 DropDownList，它从这个查询中获取数据:

    using (ProjectEntities myEntities = new ProjectEntities ())
                {
                    var q = (from c in myEntities.Customers orderby c.Name select c.Name);
                    DropDownList1.DataSource = q.ToList();
                    DropDownList1.DataBind();
}

如何只获取唯一的名称？

Answer 1

只需添加 Distinct

 var q = (from c in myEntities.Customers orderby c.Name select c.Name);
 DropDownList1.DataSource = q.ToList().Distinct();

或查询本身，

 var q = (from c in myEntities.Customers orderby c.Name select c.Name).Distinct();