在使用实体框架的C#中，是否可以从多个表的联合SQL查询中获得结果？

using System;
using System.Linq;

// 创建实体类
public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Order
{
    public int Id { get; set; }
    public int CustomerId { get; set; }
    public decimal Amount { get; set; }
}

// 创建实体框架上下文
public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
    public DbSet<Order> Orders { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("连接字符串");
    }
}

// 查询多个表的联合结果
public static void Main(string[] args)
{
    using (var context = new MyDbContext())
    {
        var query = from customer in context.Customers
                    join order in context.Orders on customer.Id equals order.CustomerId
                    select new { customer.Name, order.Amount };

        foreach (var result in query)
        {
            Console.WriteLine($"Customer: {result.Name}, Amount: {result.Amount}");
        }
    }
}