Get list of child table columns in linq query

Question

HI i have a 5 tables in my DB(templatecomponentsMappingcomponentsMasterAppointmentMappingAppointmentMaster) template : table has column templateID componentsMapping : it has templateIDcomponentID and etc... componentsMaster : it has componentIDcomponentName appointmentMapping : it has templateIDappointmentTypeID appointmentMaster : it has templateIDappointmentTypeID 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

Lokesh K · Answer

Hi Patel i tried with below code but from componentsMapping table im not getting list of records for particular templateID. pls correct me where is the problem var templateDetails = _unitOfWork.Repository ().GetEntityAsQuerable() .Join(_unitOfWork.Repository ().GetEntityAsQuerable() template => template.templateID compMapping => compMapping.templateID (template compMapping ) => new { template compMapping }) .Join(_unitOfWork.Repository ().GetEntityAsQuerable() clinicalmap => clinicalmap.compMapping.ComponentID clinicalmas => clinicalmas.ComponentID (clinicalmap clinicalmas) => new { clinicalmap clinicalmas }) .Where (x => x.templateID == templateId) .Select(x => new TemplateDTO { EncounterTemplateID = x.EncounterTemplateID EncounterTemplateName = x.EncounterTemplateName ClinicalCompList = new List () { new EncounterTemplateComponentDTO { ClinicalComponent = new ClinicalComponentDTO { ClinicalComponentID = x.apttypemap.templatemap.clinicalmas.ClinicalComponentID ClinicalComponentName = x.apttypemap.templatemap.clinicalmas.ClinicalComponentName } } } AppointmentTypesList = new List () { new EncApptTypesMappingDto { AppointmentType = new AppointmentTypeDto { AppointmentTypeId = x.apttypemas.AppointmentTypeId AppointmentType = x.apttypemas.Value } } } }).FirstOrDefault(); Regards Lokesh

Tapan Patel · Answer

Did you try something? Please describe if you have.