Nested one-to-many tables SQLite-Net Extensions

Question

I have 4 tables that I'm trying to create: Term, Courses, Assessments, and Notes. Term has a one-to-many relationship with Courses, and Courses has a one-to-many relationship with Assessments and Notes.

My question is, is it possible to format my objects to pull everything with a single call to database.GetAllWithChildrenAsync();, or does SQLite-Net Extensions not work like that.

I've tried many many different things, but Assessments and Notes never pull over. I can pull each term and their associated Courses, but the Courses associated Assessments and Notes are always null. I asked another question that is similar here, but for this question I'm simply wondering if it's even possible.

If anyone has any code that contains a working nested one-to-many implementation, that would be greatly appreciated. The documentation here includes many examples, none of which that shows nested one-to-many relationships. I've been stuck on this issue for several days now and am starting to go a bit crazy.

[Extra Info] I've tried various different insertion methods (mixtures of each as well), including the following:

• Insert each object separately then call UpdateWithChildrenAsync(term).
• Adding Cascading options of to both Terms and Courses.
• Toggling recursion on both InsertWithChildrenAsync and GetAllWithChildrenAsync.
• [Note] Toggling recursion on GetAllWithChildrenAsync with Cascading Options for either all or read result in the app immediately crashing.