如何在ASP.NET核心应用编程接口控制器中获取多个表的记录

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;

namespace YourNamespace.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class YourController : ControllerBase
    {
        private readonly YourDbContext _context;

        public YourController(YourDbContext context)
        {
            _context = context;
        }

        [HttpGet]
        public ActionResult<IEnumerable<YourViewModel>> GetRecords()
        {
            var records = _context.Orders
                .Include(o => o.OrderItems)
                .Select(o => new YourViewModel
                {
                    OrderId = o.Id,
                    OrderDate = o.Date,
                    Items = o.OrderItems.Select(oi => new YourItemViewModel
                    {
                        ItemId = oi.Id,
                        ItemName = oi.Name
                    }).ToList()
                })
                .ToList();

            return records;
        }
    }

    public class YourDbContext : DbContext
    {
        public DbSet<Order> Orders { get; set; }
        public DbSet<OrderItem> OrderItems { get; set; }

        // Configure your database connection here
    }

    public class Order
    {
        public int Id { get; set; }
        public DateTime Date { get; set; }
        public List<OrderItem> OrderItems { get; set; }
    }

    public class OrderItem
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public class YourViewModel
    {
        public int OrderId { get; set; }
        public DateTime OrderDate { get; set; }
        public List<YourItemViewModel> Items { get; set; }
    }

    public class YourItemViewModel
    {
        public int ItemId { get; set; }
        public string ItemName { get; set; }
    }
}