public async Task CountUsers_NoMatchEmailAddress_Return0()
{
await TestRunner.ExecuteStoredProcedureNonQueryAsync("dbo.AddUser",
new SqlQueryParameter("FirstName", "Jamie"),
new SqlQueryParameter("LastName", "Burns"),
new SqlQueryParameter("EmailAddress", "*****@*****.**"),
new SqlQueryParameter("StartDate", DateTime.Parse("01-Mar-2020")),
new SqlQueryParameter("NumberOfHats", 14),
new SqlQueryParameter("Cost", 15.87));
ScalarResult <int> result = await TestRunner.ExecuteStoredProcedureScalarAsync <int>("dbo.CountUsers", new SqlQueryParameter("EmailAddress", "*****@*****.**"));
result
.AssertValue(0);
result
.AssertValue(Comparisons.IsNotNull());
}