Join with lambda Expression only

Question

With LINQ no problem. Now, how do I make a join with two or more tables? Below the attempt of the join that I couldn’t go through with. Two tables(T_Acao and T_ProximaAcao). Field in join is the IDAcao

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

How do I finish this Join?

Answer 1

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();