How to create a dynamic INNER JOIN Multiple Colums

Question

I Would like to build the dynamic Linq to Sql query for inner join clause where inner join will include multiple dynamic columns for joining.

Below is the query at compile time which i need to acheive dynamically:

var source = lParent.GroupJoin(lChild,
    p => new{ p.PID,p.CategoryId (These are dynamic columns)}
    c => new{ c.PID,c.CategoryId (These are dynamic columns)}
    (p, g) =>  new { Parent = p, Childs= g })

Thank you.

What do you mean by "dynamically"? Will the user determine what columns to join on or do you want to re-use a query with different joins? Having dynamic join clauses seems odd. — D Stanley, Jan 20 '16 at 16:43

score 0 · Answer 1 · edited May 25 '17 at 07:42

0

You can use the below query to have inner join. Use GroupJoin code from this link.

source.AsQueryable()
.GroupJoin(destination.AsQueryable(),
           outer.ToString(),
           inner.ToString(),
           "new (outer as sources, group as destinations)")
.SelectMany("destinations", "new(outer as sources, inner as destinations)");

edited May 25 '17 at 07:42

Mantas Čekanauskas

2,218
6
23
43

answered Jan 20 '16 at 16:40

Ashutosh

53
6

How to create a dynamic INNER JOIN Multiple Colums

1 Answers1