Join with lambda expression only

Question

Join with lambda expression only

Navigation

#1 by (2 votes)

1

With LINQ without problems. Now, how do I join with two or more tables? Below the join attempt I could not go through to the end. Two tables ( T_Acao and T_ProximaAcao ). Field in join is IDAcao

var resultadoAcao = (db.T_Acao
                                    .Where(a => a.IDAcao == 7)
                                    .Join(db.T_ProximaAcao, p => p.IDAcao )
                                );

How do I end this join?

c# linq

asked by anonymous 27.05.2014 / 16:34

1 answer

Using Codeigniter inside Wordpress How to display a sequence of images from a single link?

score 2 · Accepted Answer

Solved. A colleague passed me:

var resultadoAcao = (db.T_Acao.Join(
                                    db.T_ProximaAcao,
                                    t1 => t1.IDAcao,
                                    t2 => t2.IDAcao,
                                    (t1, t2) => new { t1, t2})
                                    .Where( a => a.t1.IDAcao == 7)
                                     .Select(i => new {acao = i.t1.Acao, proximaacao = i.t2.ProximaAcao})
                                ).ToList();