charan sri

charan sri

  • NA
  • 10
  • 22k

subquery in lambda expression

Jun 21 2012 10:39 AM
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........

Answers (1)