What to do when the table is both a Parent and Child

I think the answer would depend on UI. Are you showing all book reports or are you picking a student or teacher first to narrow down book reports?

Sergey Barskiy

Principal Consultant

office: 678.405.0687 | mobile: 404.388.1899

Magenic ®

Microsoft Worldwide Partner of the Year | Custom Development Solutions, Technical Innovation

I'm new to CSLA, and have been thrown into rather quickly; I've tried searching for this answer already but haven't been able to locate it (most likely because I'm not entirely certain how to word what I'm searching for)

I have table that is both a parent to another table (one-to-many relationship) and has a (many-to-one) relationship with two other tables; in my attached diagram, this table would be the "book reports" table (real table names changed to protect the innocent).

We use NHibernate to map from the Database to DTOs, and then CSLA for our Business objects. My problem is how to properly set-up my business object so that I can get/set instances of the "Student" and "Teacher" objects through the "Book Reports" business object. (I hope that makes sense).

Can someone please point me in the right direction?

Thank you.

Ok, then here is my take on design:

1.       BookReports (BLB)

a.       Book Report (BB)

i.         Teacher (one, not list since it is 1-n relationship, probably ROB if you cannot modify it, which is my assumption)

ii.       Student (one, not list since it is 1-n relationship, probably ROB if you cannot modify it, which is my assumption)

I would load appropriate teacher and student during fetch of each Book Report.

Sergey Barskiy

Principal Consultant

office: 678.405.0687 | mobile: 404.388.1899

Magenic ®

Microsoft Worldwide Partner of the Year | Custom Development Solutions, Technical Innovation

Thanks for the quick response:

We're showing all book reports in a list.