EF Core leftjoin

约 61 字小于 1 分钟

2024-03-16

GroupJoin结合SelectMany

var joinResults = dbContext
                            .Person
                            .GroupJoin(dbContext.Products, person => person.Id, product => product.Id, (person, products) => new { Person = person, Products = products })
                            .SelectMany(combination => combination.Products.DefaultIfEmpty(), (person, products) => new { PersonId = person.Person.Id, PersonName = person.Person.Name, ProductsId = products.Id, ProductsName = products.Product }).ToList();