如何使用Microsoft.EntityFrameworkCore连接多个表？

// 实体类
public class TableA
{
    public int Id { get; set; }
    public string Name { get; set; }

    public ICollection<TableB> TableBs { get; set; }
}

public class TableB
{
    public int Id { get; set; }
    public string Title { get; set; }

    public int TableAId { get; set; }
    public TableA TableA { get; set; }
}

// DbContext
public class YourDbContext : DbContext
{
    public DbSet<TableA> TableAs { get; set; }
    public DbSet<TableB> TableBs { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<TableA>()
            .HasMany(a => a.TableBs)
            .WithOne(b => b.TableA)
            .HasForeignKey(b => b.TableAId);
    }
}

// 查询数据
using (var context = new YourDbContext())
{
    var query = context.TableAs.Include(a => a.TableBs);

    foreach (var item in query)
    {
        Console.WriteLine(item.Name);
        foreach (var subItem in item.TableBs)
        {
            Console.WriteLine("- " + subItem.Title);
        }
    }
}