A left join in LINQ took three calls.
In EF Core 10 it takes one.
BEFORE
.
GroupJoin(…)
.
SelectMany(…)
.
DefaultIfEmpty()
NOW
.LeftJoin(…)
THE SQL BOTH OF THEM SEND
SELECT
c.Name, o.Code, o.Total
FROM
Customers
AS
c
LEFT JOIN
Orders
AS
o
ON
c.Id = o.CustomerId
.NET 10 · EF Core 10.0.12 ·
both forms, the same SQL
on SQLite and on SQL Server
gdhami.net