Convert Sql Query Into Lambda Expression

Here is my sql query i want to convert it into lambda expression Select P.PlaceName As UnitNumber, PB.PlaceName, A.Locality, A.SubLocality, A.Sublo

Solution 1:

Query expression is much simpler in this case. I don't recommend you to use lambdas with many joins

from l in db.Listing
join p in db.Place on l.PlaceId equals p.Id
join pb in db.Place on p.ParentPlaceId equals pb.Id
join a in db.Address on pb.AddressId equals a.Id
where l.Id == 9selectnew {
   UnitNumber = p.PlaceName,
   pb.PlaceName,
   a.Locality,
   a.SubLocality,
   a.Sublocality_Level_1
}

db is your context