linq query for joining three tables

Question

0.00/5 (No votes)

See more:

I have three tables table1(main table),table2,table3. table1 contains table1Id,table2 and table3 contains table2Id,table2RoleId,table3Id,table3RoleId.

with the same value of table1Id,more than one record in table2Id and table3Id but the table2RoleId's and table3RoleId's are different.

I want to join table1 with table2 and table3 to display like Table2RoleId and Table3RoleId has to display according to the Table1Id

Posted 5-Oct-12 18:16pm

charan1431

Updated 5-Oct-12 18:17pm

Kenneth Haugland

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2012-10-05T18:42:00

Solution 1

please refer this links..

Master-Detail Join[^]

One to many join[^]

Posted 5-Oct-12 18:42pm

Tejas Vaishnav

Comments

charan1431 6-Oct-12 0:50am

I have already implemented this but I am not getting the exact result

Tejas Vaishnav 6-Oct-12 2:04am

so please use a Improve Question functionality and provide your data as well as also provide desired output. with your already tried query.

Strange_Pirate 18-Mar-13 8:29am

And one request to you too.
Please use proper ENGLISH