convert sql query into lambda expression [closed]

by

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 == 9
select new {
   UnitNumber = p.PlaceName,
   pb.PlaceName,
   a.Locality,
   a.SubLocality,
   a.Sublocality_Level_1
}

db is your context

More Related Contents:

  1. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  2. Is there a good LINQ way to do a cartesian product?
  3. LINQ to SQL – Left Outer Join with multiple join conditions
  4. linq case statement
  5. LINQ to SQL multiple tables left outer join
  6. Equivalent of SQL ISNULL in LINQ?
  7. Distinct in Linq based on only one field of the table
  8. Could not find an implementation of the query pattern
  9. Wildcard search for LINQ
  10. Get an IDataReader from a typed List
  11. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  12. Entity Framework. Delete all rows in table
  13. Use linq to generate direct update without select
  14. Join and Include in Entity Framework
  15. How to make LINQ execute a (SQL) LIKE range search
  16. Calling a SQL User-defined function in a LINQ query
  17. Issues Doing a String Comparison in LINQ
  18. Convert SQL to LINQ Query [closed]
  19. Linq To Sql compare Time only
  20. Linq union usage?
  21. Where IN clause in LINQ [duplicate]
  22. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  23. LINQ, Where() vs FindAll()
  24. Exception using CopyToDataTable with “new {..}” LINQ query
  25. C# constructing parameter query SQL – LIKE %
  26. Custom Method in LINQ to SQL query
  27. What is passing parameters to SQL and why do I need it?
  28. Using Linq Except not Working as I Thought
  29. What is the purpose of AsQueryable()?
  30. Enabling Foreign key constraints in SQLite

Leave a Comment