After going through all docs from learndapper.com and navigating through kind-of similar questions on StackOverflow I think I need some help.

Some context
On a blazor (interactive SSR) application page I need to retrieve project information that is stored in SQL db.

A project (dbo.Projects) can contain no, 1 or more project phases (dbo.ProjectPhase) and a project phase can contain no, 1 or more project items (dbo.ProjectItems). Note: this isn’t the full structure but I think if i know how to retrieve this adding additional levels should be no problem.

db schema

The class looks like this:
project class

The Dapper example (https://www.learndapper.com/relationships) does not fit my usecase because it’s only class with a list but in my usecase the latter also has a list.

So what do i want?
I want to make a class object in c# that has a list of projectphase and each projectphase has a list of projectitems.

Any idea how to do this, or maybe a link to someone else asking the same question that I missed.

Your help is highly appreciated

Reading all docs on learndapper.com, but I could not translate it to my usecase
Reading other questions but to no success