I have Course, Unit and Lesson tables. Each table has ID and Name Columns.
We don’t have relations in database and in LINQ designer. We relate using IDs.
The relation is, each course has multiple units. Each unit has multiple lessons.
I also have Course, Unit and Lesson classes having ID, Name and Child list.
I want to get the Course collection and associated child objects using stored procedure (LINQ to SQL).
I am not really sure how to implement this.
Could you please advice me to resolve this issue?