I have a repo setup for a parent object (season). That season object contains a child object (schedule). Then that object has a child object called Match.

When retrieving records via

```
season.Schedules.AsQueryable().Where(s => s.Week == 1).ToList();

```

It's only returning "Match" records for the first 2 schedules. If I go to SSMS, it's returning the "Match" records for ALL of the schedules.

Here are the mappings for the objects:

Season:

```
HasMany(x => x.Schedules).KeyColumn("SeasonId");

```

Schedule:

```
HasOne(x => x.Match).ForeignKey("MatchId");

```

Here's my view where I try and iterate over the matches, where the first 2 work, and all the remaining "Match" objects are null (but they are populated when "querying" in SSMS.

```
@model LeagueManager.Models.MatchModel
@foreach (var schedule in Model.Schedules.Where(s => s.Week == 1))
        {
            <div class="row">@schedule.Match.MatchResults25Game.Game1.PlayerA.DisplayName vs @schedule.Match.MatchResults25Game.Game1.PlayerB.DisplayName</div>
            <div class="row">@schedule.Match.MatchResults25Game.Game2.PlayerA.DisplayName vs @schedule.Match.MatchResults25Game.Game2.PlayerB.DisplayName</div>
            <div class="row">@schedule.Match.MatchResults25Game.Game3.PlayerA.DisplayName vs @schedule.Match.MatchResults25Game.Game3.PlayerB.DisplayName</div>
            <div class="row">@schedule.Match.MatchResults25Game.Game4.PlayerA.DisplayName vs @schedule.Match.MatchResults25Game.Game4.PlayerB.DisplayName</div>
            ........
}

```

What are some ways to help me figure out why it's not returning all of the "Match" values, or is there something wrong with how I have everything setup (I wouldn't think so since the first 2 records come back ok...)

Let me know if more background information is needed.

**UPDATE**  

Here's what I get from Express Profiler:

```
exec sp_executesql N'
SELECT schedules0_.SeasonId as SeasonId2_,
schedules0_.ScheduleId as ScheduleId2_,
schedules0_.ScheduleId as ScheduleId12_1_,
schedules0_.Week as Week12_1_,
schedules0_.MatchNumber as MatchNum3_12_1_,
schedules0_.MatchDate as MatchDate12_1_,
schedules0_.SeasonId as SeasonId12_1_,
schedules0_.TeamA as TeamA12_1_,
schedules0_.TeamB as TeamB12_1_,
match1_.MatchId as MatchId3_0_,
match1_.MatchResults25GameId as MatchRes2_3_0_
FROM Schedule schedules0_
left outer join Match match1_ on schedules0_.ScheduleId=match1_.MatchId
WHERE schedules0_.SeasonId=@p0',N'@p0 int',@p0=1
go

```