public void Get_all_studentschools_returns_studentschools()
{
using (var context = new FIFContext(ContextOptions))
{
var repository = new StudentSchoolRepository(context);
var result = repository.All().Result;
result.Count.ShouldBe(2);
result.ShouldSatisfyAllConditions(
() => result.ElementAt(0).StudentSchoolKey.ShouldBe("1-1"),
() => result.ElementAt(0).StudentKey.ShouldBe("1"),
() => result.ElementAt(0).SchoolKey.ShouldBe("1"),
() => result.ElementAt(0).SchoolYear.ShouldBe("2012"),
() => result.ElementAt(0).StudentFirstName.ShouldBe("Tommas"),
() => result.ElementAt(0).StudentMiddleName.ShouldBeNull(),
() => result.ElementAt(0).StudentLastName.ShouldBe("McCarthy"),
() => result.ElementAt(0).EnrollmentDateKey.ShouldBe("20120101"),
() => result.ElementAt(0).GradeLevel.ShouldBe("Ninth grade"),
() => result.ElementAt(0).PictureURL.ShouldBe("Some url for the picture"),
() => result.ElementAt(0).LimitedEnglishProficiency.ShouldBeNull(),
() => result.ElementAt(0).IsHispanic.ShouldBe(false),
() => result.ElementAt(0).Sex.ShouldBeNull());
result.ShouldSatisfyAllConditions(
() => result.ElementAt(1).StudentSchoolKey.ShouldBe("2-1"),
() => result.ElementAt(1).StudentKey.ShouldBe("2"),
() => result.ElementAt(1).SchoolKey.ShouldBe("1"),
() => result.ElementAt(1).SchoolYear.ShouldBe("2012"),
() => result.ElementAt(1).StudentFirstName.ShouldBe("Matthew"),
() => result.ElementAt(1).StudentMiddleName.ShouldBeNull(),
() => result.ElementAt(1).StudentLastName.ShouldBe("Simpson"),
() => result.ElementAt(1).EnrollmentDateKey.ShouldBe("20120101"),
() => result.ElementAt(1).GradeLevel.ShouldBe("Eighth grade"),
() => result.ElementAt(1).LimitedEnglishProficiency.ShouldBeNull(),
() => result.ElementAt(1).IsHispanic.ShouldBe(true),
() => result.ElementAt(1).Sex.ShouldBe("Male"));
}
}
