Inner Join - Self Servicing

Posts   
 
    
Posts: 3
Joined: 10-Mar-2010
# Posted on: 10-Mar-2010 19:25:22   

I cannot for the life of me figure this out, and I hope someone can help. I have to bind data that comes from several DIFFERNT tables to an asp.net Grid. (kind of an aggregate view)

A customer (custID) can have multiple cars(via FK) each customervehicle(via FK to vehicle table) has several FK relationships to other tables used to describe that vehicle. I need to display data out of the CustomerVehicle ->Vehicle->VehicleType tables.

Anyone give a pointer on how to do that?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 11-Mar-2010 03:44:59   

What you are looking for is [urldesciption"DynamicLists"]http://llblgen.com/documentation/2.6/hh_goto.htm#Using%20the%20generated%20code/SelfServicing/Using%20TypedViews%2C%20TypedLists%20and%20Dynamic%20Lists/gencode_usingdynamiclists.htm[/url]. These are objects you can build on the fly in the code mixing the entities and joining them with the pre-built relations. Check the link for more information.

You also can do that with TypedViews. These are DB views mapped onto typed objects. Please check if that is helpful to you.

Regards

David Elizondo | LLBLGen Support Team