Linq join iquery, how to use defaultifempty

by

You basically want to do a left outer join. The way you currently are using the DefaultIfEmpty method is that if the entire list is empty you provide a single default entry.

You should join with PassengerDetails and for each passenger details list call the default if empty. This is the equivalent of a left outer join and it goes a little something like this:

var data = from fd in FlightDetails
           join pd in PassengersDetails on fd.Flightno equals pd.FlightNo into joinedT
           from pd in joinedT.DefaultIfEmpty()
           select new {
                         nr = fd.Flightno,
                         name = fd.FlightName,
                         passengerId = pd == null ? String.Empty : pd.PassengerId,
                         passengerType = pd == null ? String.Empty : pd.PassengerType
                       }

More Related Contents:

  1. MVC 4 how pass data correctly from controller to view
  2. System.Linq.Expression.Compile error
  3. Remove duplicates in the list using linq
  4. Sort a list from another list IDs
  5. When to use Cast() and Oftype() in Linq
  6. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  7. Using Linq to group a list of objects into a new grouped list of list of objects
  8. Setting the default JSON serializer in ASP.NET MVC
  9. Lambda/Linq with Contains criteria for multiple keywords
  10. LINQ: Select an object and change some properties without creating a new object
  11. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  12. How to write Asynchronous LINQ query?
  13. JContainer, JObject, JToken and Linq confusion
  14. How do you perform a CROSS JOIN with LINQ to SQL?
  15. LIKE operator in LINQ
  16. Why can’t I call an extension method from a base class of the extended type‏?
  17. GroupBy on complex object (e.g. List)
  18. Enumerating through an object’s properties (string) in C#
  19. client-side validation in custom validation attribute – asp.net mvc 4
  20. Return list using select new in LINQ
  21. Intersect LINQ query
  22. LINQ – Query syntax vs method chains & lambda [closed]
  23. ASP.NET MVC 4 + Ninject MVC 3 = No parameterless constructor defined for this object
  24. Resolving extension methods/LINQ ambiguity
  25. Get previous and next item in a IEnumerable using LINQ
  26. How to force BundleCollection to flush cached script bundles in MVC4
  27. How to use LINQ Distinct() with multiple fields
  28. LINQ query to return a Dictionary
  29. LINQ: Select where object does not contain items from list
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment