Get list of child table columns in linq query

Question

HI,

 

i have a 5 tables in my DB(template,componentsMapping,componentsMaster,AppointmentMapping,AppointmentMaster)

 

template : table has column templateID

componentsMapping : it has templateID,componentID and etc...

componentsMaster : it has componentID,componentName

appointmentMapping : it has  templateID,appointmentTypeID

appointmentMaster : it has templateID,appointmentTypeID 

 

componentsMapping and appointmentMapping is a mapping tables. 

 

now i need to take input as templateID from template table so  based on that i should get the list of data from componentsMapping and appointmentMapping table using linq

 

Regards,

Lokesh