Linq At least one object must implement IComparable

Question

I am trying to order a list of objects containing a different list of Entities. I have implemented IComparable for all objects and still get an exception. In all the examples that I saw, the problem is considered when you have one list and you order a given field in this list, but not where you have a list of lists. This issue occurs for Linq for the objects below, as well as for Linq for Entities. What am I missing?

[TestClass]
public class OrderBy
{
    [TestMethod]
    public void OrderByTest()
    {
        var hobbies = new Collection<Hobby> { new Hobby { HobbyId = 1, Name = "Eating" }, new Hobby() { HobbyId = 2, Name = "Breathing" } };

        var p1 = new Person
        {
            PersonId = 1,
            Name = "A",
            PersonHobbies = new Collection<PersonHobby> { new PersonHobby() { PersonHobbyId = 1}}
        };
        var p2 = new Person
        {
            PersonId = 2,
            Name = "Z",
            PersonHobbies = new Collection<PersonHobby> { new PersonHobby() { PersonHobbyId = 2 }}
        };

        var people = new List<Person> { p1, p2 };
        var pplEnumerable = people.AsEnumerable();
        pplEnumerable = pplEnumerable.OrderByDescending(r => r.PersonHobbies.OrderByDescending(p => p.Hobby.Name));
        foreach (var person in pplEnumerable)
        {
            Console.WriteLine(person.Name);
        }
    }
    public class Person : IComparable
    {
        public int PersonId { get; set; }
        public string Name { get; set; }
        public virtual ICollection<PersonHobby> PersonHobbies { get; set; }
        public int CompareTo(object obj)
        {
            if (obj == null) return 1;
            var otherPerson = obj as Person;
            return PersonId.CompareTo(otherPerson.PersonId);
        }
    }
    public class PersonHobby : IComparable
    {
        public int PersonHobbyId { get; set; }
        public int HobbyId { get; set; }
        public virtual Person Person{ get; set; }
        public int PersonId { get; set; }
        public virtual Hobby Hobby { get; set; }
        public int CompareTo(object obj)
        {
            if (obj == null) return 1;
            var otherPersonHobby = obj as PersonHobby;
            return PersonHobbyId.CompareTo(otherPersonHobby.PersonHobbyId);
        }
    }
    public class Hobby : IComparable
    {
        public int HobbyId { get; set; }
        public string Name { get; set; }
        public int CompareTo(object obj)
        {
            if (obj == null) return 1;
            var otherHobby = obj as Hobby;
            return HobbyId.CompareTo(otherHobby.HobbyId);
        }
    }
}

Answer 1

. (, EquatableList ..) LINQ Except Intersect .

, LINQ:

select * from Person p join PersonHobby ph 
on ph.PersonId = p.PersonId join Hobby h 
on h.HobbyId = ph.HobbyId order by h.Name

:

var query = people.SelectMany(p => p.PersonHobbies)
                  .Join(hobbies, ph => ph.HobbyId, h => h.HobbyId, 
                        (ph, h) => new 
                        { 
                         Person = ph.Person, PersonHobby = ph, Hobby = h 
                        })
                  .OrderBy(r => r.Hobby.Name);

, , , hobby.name, SQL.