使用LINQ LAMBDA连接基于公共id的两个类

我想使用lambda/linq，基于一个公共id连接到两个类，该公共id从父表中产生一行，从子表中产生两行。我已经在下面粘贴了，到目前为止我已经尝试过了，但我得到的是每行10行，这是不正确的。欢迎对守则提出任何建议或修订。

类

namespace x
{
    public class IntegrationSearchResult
    {
        public string Dfe { get; set; }
        public SchoolResult SchoolSearchResult { get; set; }
        public List<PupilResult> PupilSearchResult { get; set; }
    }
    public class SchoolResult
    {
        public int SupplierId { get; set; }
        public string SchoolName { get; set; }              
        public DateTime CreateDate { get; set; }
        public int Pupils { get; set; }     
    }
    public class PupilResult
    {
        public int SupplierId { get; set; }     
        public string FirstName { get; set; }
        public string LastName { get; set; }        
    }
}

功能

private Func<IEnumerable<IntegrationSearchResult>> _getAllDummySearchResults;
private Func<string, IntegrationSearchResult> _getDfeDummySearchSchool;

我实现结果的尝试

_

getAllDummySearchResults = () => (from dummySupplierId in Enumerable.Range(1, 10)                                                      
    select new IntegrationSearchResult
    {
        Dfe = "School-1-" + dummySupplierId.ToString("000000"),
        SchoolSearchResult = new SchoolResult
        {
            SupplierId = dummySupplierId,
            SchoolName = "SchoolName" + dummySupplierId.ToString("000000"),         
            CreateDate = new DateTime(),
            Pupils = 123            
        }
        ,
        PupilSearchResult = new List<PupilResult>
        {
            new PupilResult
            {
                SupplierId = dummySupplierId,                    
                FirstName = "FirstName - Pupil-1-" + dummySupplierId.ToString("000000"),
                LastName = "LastName - Pupil-1-" + dummySupplierId.ToString("000000")
            },
            new PupilResult
            {
                SupplierId = dummySupplierId,
                FirstName = "FirstName - Pupil-2-" + dummySupplierId.ToString("000000"),
                LastName = "LastName - Pupil-2-" + dummySupplierId.ToString("000000")
            }
        }
    }).ToList();
    _getDfeDummySearchSchool = dfe =>
    {
        var allSchools = _getAllDummySearchResults();
        return allSchools.FirstOrDefault(x => x.Dfe == dfe);
    };

预期结果：学校搜索结果应显示一行及其对应的学生，即具有相同供应商id的两行。

{
  "Dfe": 0,
  "SchoolSearchResult": [
    {
      "SupplierId": 1,
      "SchoolName": "SchoolName000001",
      "CreateDate": "0001-01-01T00:00:00",
      "Pupils": 123
    }],
     "PupilSearchResult": [
    {
      "SupplierId": 1,
      "FirstName": "FirstName - Pupil-1-000001",
      "LastName": "LastName - Pupil-1-000001"
    },
    {
      "SupplierId": 1,
      "FirstName": "FirstName - Pupil-1-000002",
      "LastName": "LastName - Pupil-1-000002"
    }]
    }

getAllDummySearchResults = () => (from dummySupplierId in Enumerable.Range(1, 10)                                                      
    select new IntegrationSearchResult
    {
        Dfe = "School-1-" + dummySupplierId.ToString("000000"),
        SchoolSearchResult = new SchoolResult
        {
            SupplierId = dummySupplierId,
            SchoolName = "SchoolName" + dummySupplierId.ToString("000000"),         
            CreateDate = new DateTime(),
            Pupils = 123            
        }
        ,
        PupilSearchResult = new List<PupilResult>
        {
            new PupilResult
            {
                SupplierId = dummySupplierId,                    
                FirstName = "FirstName - Pupil-1-" + dummySupplierId.ToString("000000"),
                LastName = "LastName - Pupil-1-" + dummySupplierId.ToString("000000")
            },
            new PupilResult
            {
                SupplierId = dummySupplierId,
                FirstName = "FirstName - Pupil-2-" + dummySupplierId.ToString("000000"),
                LastName = "LastName - Pupil-2-" + dummySupplierId.ToString("000000")
            }
        }
    }).Take(1).ToList();