Join Multiple tables in c#

Question

            var z = from x in resp1.table1
                    join y in resp2.table2 on x.fields equals y.fields
                    select
                    new {y.fields, y.fields1, x.fields2, x.fields3, x.fields4};

And I want a new table so basically I want to join three or more tables but I dont know how

the Table 1 have the primary key of table2 and table3, and I want to have all the fields of table2 and table3. How should I do it? — Therence
– Therence, Commented Sep 19, 2012 at 4:05
No. but I dont know how to query three tables. As you can see in my code above it only have two tables. And I want to have to join three tables which is the table1 have the primary key of table2 and table3. — Therence
– Therence, Commented Sep 19, 2012 at 4:11

Community · Accepted Answer · 2017-05-23 11:55:56Z

1

var z = from x in resp1.table1
        join y in resp2.table2 on x.fields equals y.fields
        join z in resp3.table3 on x.fields equals z.fields
        select
        new {y.fields, y.fields1, x.fields2, x.fields3, x.fields4, z.fields5, z.fields6};

And so on... But first check if you really need a triple join!

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Sep 19, 2012 at 4:10

Erre Efe

15.6k10 gold badges48 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Therence Over a year ago

Lastly how can I short it ascending using the table1 fields?

Erre Efe Over a year ago

@Therence before the select line use orderby fieldName1, fieldName2 replacing the fieldNames with the proper ones.

Dylan Smith · Accepted Answer · 2012-09-19 04:14:11Z

0

var z = from x in resp1.table1
        join y in resp2.table2 on x.fields equals y.fields
        join z in resp3.table3 on x.fields equals z.fields
        select
        new {y.fields, y.fields1, x.fields2, x.fields3, x.fields4, z.fields5};

answered Sep 19, 2012 at 4:14

Dylan Smith

22.3k2 gold badges51 silver badges63 bronze badges

1 Comment

Therence Over a year ago

Lastly how can I short it ascending using the table1 fields?

Collectives™ on Stack Overflow

Join Multiple tables in c#

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related