ASP.NET Core & EntityFramework Core: Left (Outer) Join in Linq

by

If you need to do the Left joins then you have to use into and DefaultIfEmpty() as shown below.

var result = from person in _dbContext.Person
             join detail in _dbContext.PersonDetails on person.Id equals detail.PersonId into Details
             from m in Details.DefaultIfEmpty()
               select new
                {
                    id = person.Id,
                    firstname = person.Firstname,
                    lastname = person.Lastname,
                    detailText = m.DetailText
                };

You can learn more about it : Left Outer Join in LINQ to Entities

More Related Contents:

  1. Dynamically access table in EF Core 2.0
  2. loading a full hierarchy from a self referencing table with EntityFramework.Core
  3. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  4. LINQ: Distinct values
  5. Entity Framework: There is already an open DataReader associated with this Command
  6. LINQ-to-SQL vs stored procedures? [closed]
  7. How to run stored procedures in Entity Framework Core?
  8. Dynamically change connection string in Asp.Net Core
  9. How to view LINQ Generated SQL statements?
  10. How to view LINQ Generated SQL statements?
  11. LINQ across multiple databases
  12. LINQ Join with Multiple Conditions in On Clause
  13. why remove-migration run my app?
  14. How can I reject all changes in a Linq to SQL’s DataContext?
  15. Unable to create migrations after upgrading to ASP.NET Core 2.0
  16. Dynamically changing schema in Entity Framework Core
  17. Sum of items in a collection
  18. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  19. How to update the model when using database first approach
  20. How to dynamically add OR operator to WHERE clause in LINQ
  21. Linq To Sql – Dynamic OrderBy – Case When
  22. Loop/reflect through all properties in all EF Models to set Column Type
  23. ASP.NET Core change EF connection string when user logs in
  24. Avoid or control circular references in Entity Framework Core
  25. Greater Than Condition in Linq Join
  26. How do I write this cross apply query in LINQ-to-SQL?
  27. How to load navigation properties on an IdentityUser with UserManager
  28. Implementing recursive property loading in EF Core
  29. Run database migrations using Entity Framework core on application start
  30. How to resolve .net core build error NETDSDK1061 and warning MSB3277

Leave a Comment