LinQ to Entities: Query with four tables JOIN

Answer 1

Have you tried doing linq joins:

http://stackoverflow.com/questions/32433/linq-select-with-multiple-tables

Answer 2

Its along the lines:

var detalleQuery =
          from client in guiaContext.Clients
          where client.ID == 1
          from destination in cliente.Destinations
          from destinationDetail in destination.DestionationDetails
          where destinationDetail.Language.Iso2Code == "es"
          select destinationDetail;