c# - Linq 按 ID 加入并按名称排序

Question

假设我有 2 个对象集合(我对 here 中的示例做了一些修改)

Person magnus = new Person { Name = "Hedlund, Magnus", Id = 1 };
Person terry = new Person { Name = "Adams, Terry", Id =2 };
Person charlotte = new Person { Name = "Weiss, Charlotte", Id = 3 };

Pet barley = new Pet { Name = "Barley", Owner = 1};
Pet boots = new Pet { Name = "Boots", Owner = 2};
Pet whiskers = new Pet { Name = "Whiskers", Owner = 2};
Pet daisy = new Pet { Name = "Daisy", Owner = 3};

List<Person> people = new List<Person> { magnus, terry, charlotte };
List<Pet> pets = new List<Pet> { barley, boots, whiskers, daisy };

我现在如何根据它们的主人姓名对宠物进行排序并返回宠物集合，即我想要这样的结果:

boots, whiskers, barley, daisy.

有什么想法吗？提前致谢!

Answer 1

var query = from pet in  pets
            join person in people 
            on pet.Owner equals person.Id
            orderby person.Name
            select pet;

编辑因为你想要一个“宠物集合”:

List<Pet> result = query.ToList();