I have a list of Books (BookId) and each book is associated to a Book collection (CollectionId).
I am trying to figure out the best way to group the results by Collection, so all the books that belong to a collection are listed under it and I can build the results in the following way:
Book A,D,G belong to Collection 1. Book B,C,E belong to Collection 2.
I have the books in a list/array that I need to loop through and look up the collectionID they belong to and them need to store the new lists as seen below:
CollectionID 1:
- Book A, Book D, Book G
CollectionID 2:
- Book B, Book C, Book E
CollectionID 3:
- Book F