使用 INCLUDE（NOT JOIN）将 LINQ 转换为 LAMBDA Entity Framework Core

Question

如何在 Entity Framework Core 中使用 Include 方法（而不是 Join 方法）调用多个实体？我正在尝试将此 LINQ 查询转换为 EF Core 5 语法，但我不知道如何调用多个实体并使用 include 方法将它们连接在一起。

        var reservations = from reservation in _dbContext.Reservations
                           join customer in _dbContext.Users on reservation.UserId equals customer.Id
                           join movie in _dbContext.Movies on reservation.MovieId equals movie.Id

                           select new
                           {
                               Id = reservation.Id,
                               ReservationTime = reservation.ReservationTime,
                               CustomerName = customer.Id,
                               MovieName = movie.Name
                           };

我尝试使用多个包含和选择方法，但不知道如何调用多个实体并加入

以下是我的模型

public class Reservation
{
    public int Id { get; set; }
    public int Qty { get; set; }
    public double Price { get; set; }
    public string Phone { get; set; }
    public DateTime ReservationTime { get; set; }
    public int MovieId { get; set; }
    public int UserId { get; set; }
}

public class Movie
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Description { get; set; }
    public string Language { get; set; }
    public string Duration { get; set; }
    public DateTime PlayingDate { get; set; }
    public DateTime PlayingTime { get; set; }
    public double TicketPrice { get; set; }
    public double Rating { get; set; }
    public string Genre { get; set; }
    public string TrailorUrl { get; set; }
    public string ImageUrl { get; set; }

    [NotMapped]
    public IFormFile Image { get; set; }
    public ICollection<Reservation> Reservations { get; set; }
}

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Email { get; set; }
    public string Password { get; set; }
    public string Role { get; set; }
    public ICollection<Reservation> Reservations { get; set; }
}

控制器代码：

        var reservations = _dbContext.Reservations
            .Include(r => r.Id)
            .Include(c => c.User)
            .Select(x => new { x.Id, x.ReservationTime, x.User, x.User.Name });

Answer 1

如果添加到 Reservation 导航属性 Movie 和 User，则可以简化您的查询。 Include 不能与 Select 一起使用，它会被 EF 翻译器忽略。

var reservations = _dbContext.Reservations
    .Select(r => new             
    {
        Id = r.Id,
        ReservationTime = r.ReservationTime,
        CustomerName = r.User.Id,
        MovieName = r.Movie.Name
    });