Hi i want to create a view of items having several fields from several related entities. I can create a typed list or create a db view and use it as a typed view, however i would like to do this without involving a typed list or a typed view.

i believe creating a dataview is the way to go but i dont really know how to do it. consider i have this: - student entity with fullname and studentid - class entity with classid, courseid and section - course entity with courseid, coursename and coursecredit - enrollment entity with studentid and classid

i want my view to have students fullname, studentid, coursename and section.

thank you -shane

Nevermind. i've done it using the obvious way; datatable and dao.

-shane

DynamicLists is also a good choice. The benefit over datable+dao is that you still use LLBLGen framework objects (PredicateExpressions, Relations, GroupCollection, etc.) its persistence logic. Linq2LLBL is also an option is you like .NET3.5.