Loading

subquery in lambda expression

charan sri

14y6.1kLINQ

query= from a in table1 join b in table2 on a.id equals b.id                 where b.id in                 (from c in table3                        where c.id1==1 and c.id2==1)                   select new{}).ToArray();
how can i convert this into lambda expressions....
i wrote up to join statement like
        table1.Join(table2, i => i.id, j => j.id,(i, j))
After this how can i implement inner query........

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
var query = from a in table1 join b in table2 on a.id equals b.id select new{...};

would translate to:

var query = table1.Join(table2, i => i.id, j => j.id, (i, j) => new {...});