Copy to clipboard

var customerOrder = await ctx.Customers
                             .LeftJoin(ctx.Orders,
                                       c => c.Id,
                                       o => o.CustomerId,
                                       result => new { Customer = result.Left, Order = result.Right })
                             .ToListAsync();