如何使用EFCore获取一个表到另一个表的主键计数

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 Description { get; set; }
    public int TableAId { get; set; }
    public TableA TableA { get; set; }
}

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

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("your_connection_string");
    }
}

using (var context = new MyDbContext())
{
    var tableACounts = context.TableAs.Select(a => new
    {
        a.Id,
        a.Name,
        TableBCount = a.TableBs.Count()
    }).ToList();

    foreach (var item in tableACounts)
    {
        Console.WriteLine($"TableA Id: {item.Id}, Name: {item.Name}, TableB Count: {item.TableBCount}");
    }
}