public void GetPeopleByGender()
{
var expectedFemaleCount = 1098;
var expectedMaleCount = 898;
var ops = new SqlOperations(TestCatalog, true);
var count = ops.PersonListByGender(GenderRole.Female).Count;
Assert.IsTrue(count == expectedFemaleCount,
$"Expected {expectedFemaleCount} females in list but returned {count}");
count = ops.PersonListByGender(GenderRole.Male).Count;
Assert.IsTrue(count == expectedMaleCount,
$"Expected {expectedMaleCount} males in list but returned {count}");
}