使用 Linq 对 Person 对象列表进行排序

Question

我需要根据对象属性的类别对对象列表进行查询。我需要这些组的顺序不同于我在许多其他示例中看到的通常的字母顺序。我正在使用从其他地方获取的示例。如何根据 HomeProvince 但按照以下顺序生成 Person 对象列表：

安大略省、魁北克省、艾伯塔省、马尼托巴省、不列颠哥伦比亚省。每个组内的顺序并不重要。

Person[] people = new Person[]
{
    new Person() { FirstName = "Tony", LastName = "Montana", Age = 39, HomeProvince = "Ontario" },
    new Person() { FirstName = "Bill", LastName = "Smith", Age = 23, HomeProvince = "Ontario" },
    new Person() { FirstName = "Jane", LastName = "Doe", Age = 23, HomeProvince = "Alberta" },
    new Person() { FirstName = "John", LastName = "Doe", Age = 23, HomeProvince = "Alberta" },
    new Person() { FirstName = "Alex", LastName = "DeLarge", Age = 19, HomeProvince = "British Columbia" },
    new Person() { FirstName = "Travis", LastName = "Bickle", Age = 42, HomeProvince = "Quebec" },
    new Person() { FirstName = "Ferris", LastName = "Beuller", Age = 17, HomeProvince = "Manitoba" },
    new Person() { FirstName = "Maggie", LastName = "May", Age = 23, HomeProvince = "Ontario" },
    new Person() { FirstName = "Mickey", LastName = "Mouse", Age = 93, HomeProvince = "Alberta" },
    new Person() { FirstName = "Frank", LastName = "Darabont", Age = 49, HomeProvince = "Ontario" }
};

Answer 1

您可以这样做：

// Provinces in the desired order
string[] provinces = { "Ontario", "Quebec", "Alberta", "Manitoba", 
                       "British Columbia" };

var query = from province in provinces
            join person in people on province equals person.HomeProvince
            select person;

这基本上会：

• 忽略不在指定省份的任何人
• 按指定的省份顺序返回人员序列

如果您需要按省份分组的人员，那也很简单：

var query = from province in provinces
            join person in people on province equals person.HomeProvince
                into grouped
            select new { Province = province, People = grouped.ToList() };

另一种选择是创建从省份到“优先级”的映射并简单地按该顺序排序。这实际上取决于您需要什么作为输出。

Answer 2

我不确定这是否是最好的方法，但我可能会让每个以安大略省为家乡的人并将他们添加到数组中。然后重复魁北克等......我不知道任何其他方式，因为你需要的是“随机”。

我说数组是因为这就是您在代码示例中使用的数组。显然，只要您不在放入物品时或放入之后订购它们，那么使用哪种容器并不重要。