public void Get_StudentSchool_by_studentSchoolKey_returns_null_when_it_does_not_exist()
{
using (var context = new FIFContext(ContextOptions))
{
var repository = new StudentSchoolRepository(context);
var result = repository.Get("1-999").Result;
result.ShouldBeNull();
}
}
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"));
}
}
public void Get_StudentSchool_by_studentSchoolKey_returns_StudentSchool()
{
using (var context = new FIFContext(ContextOptions))
{
var repository = new StudentSchoolRepository(context);
var result = repository.Get("1-1").Result;
result.ShouldSatisfyAllConditions(
() => result.StudentSchoolKey.ShouldBe("1-1"),
() => result.StudentKey.ShouldBe("1"),
() => result.SchoolKey.ShouldBe("1"),
() => result.SchoolYear.ShouldBe("2012"),
() => result.StudentFirstName.ShouldBe("Tommas"),
() => result.StudentMiddleName.ShouldBeNull(),
() => result.StudentLastName.ShouldBe("McCarthy"),
() => result.EnrollmentDateKey.ShouldBe("20120101"),
() => result.GradeLevel.ShouldBe("Ninth grade"),
() => result.LimitedEnglishProficiency.ShouldBeNull(),
() => result.IsHispanic.ShouldBe(false),
() => result.Sex.ShouldBeNull(),
() => result.PictureURL.ShouldBe("Some url for the picture"));
}
}
