LINQ to SQL multiple tables left outer join

by

Here is how left outer joins are implemented with LINQ. You should use GroupJoin (join...into syntax):

from d in context.dc_tpatient_bookingd
join bookingm in context.dc_tpatient_bookingm
     on d.bookingid equals bookingm.bookingid into bookingmGroup
from m in bookingmGroup.DefaultIfEmpty()
join patient in dc_tpatient
     on m.prid equals patient.prid into patientGroup
from p in patientGroup.DefaultIfEmpty()
// ... other joins here
where d.processid == 6 &&
      ((m.branchId == 1 && d.DestinationBranchID == 0) ||
       (d.DestinationBranchID == 1 && d.sendstatus == "R"))
// ... other conditions here
orderby d.priority descending, m.bookingid
select new {
   d.bookingid,
   d.labid,
   d.processid,
   p.prid,
   p.prno,
   m.bookingid // need for grouping
} into x
group x by x.bookingid into g
select g

This query joins three tables. You can join the rest of the tables the same way.

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. Entity Framework. Delete all rows in table
  3. Join and Include in Entity Framework
  4. Calling a SQL User-defined function in a LINQ query
  5. ‘Contains()’ workaround using Linq to Entities?
  6. linq case statement
  7. How to use a string to create a EF order by expression?
  8. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  9. Distinct in Linq based on only one field of the table
  10. Wildcard search for LINQ
  11. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  12. How to compare only date components from DateTime in EF?
  13. Entity Framework error: Cannot insert explicit value for identity column in table
  14. Get an IDataReader from a typed List
  15. Dynamic MySQL database connection for Entity Framework 6
  16. Entity Framework 6 Code First Custom Functions
  17. Entity Framework – stored procedure return value
  18. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  19. Order by dynamic parameter
  20. Dynamic table name in linq [duplicate]
  21. Linq Syntax – Selecting multiple columns
  22. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  23. Creating dynamic queries with entity framework
  24. Log Queries executed by Entity Framework DbContext
  25. Get affected rows on ExecuteNonQuery
  26. Remove item from list based on condition
  27. How to group by DateTime.Date in EntityFramework
  28. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  29. Linq union usage?
  30. Querying data using Entity Framework from dynamically created table

Leave a Comment