I have a model(Participant) containing collection model repr

Question

I  have a model(Participant) containing collection model representing elements from other model(ParticipantRoles) I want to join it with Roles table on Participant.Participant.RoleId to Roles.Id. What should be LINQ query in this case.

Sant ku · Answer

Hi Pradeep Thanks for the response in my situation ParticipantRoles is part of Participant model as Collection and I want to join ParticipantRoles models in Participants Model with Roles model based on RolesId.

Pradeep Shet · Answer

Hi sant ku var result = from t1 in ParticipantRoles join t2 in Roles on t1.RoleId equals t2.Id selectt1; Hope this is what you were looking for. If this answers your query dont forget to mark it as answered.