public void ShouldCallStoredProcAsync()
{
// Arrange
IDatabaseApi databaseApi = CreateDatabaseApi();
IStoreProcParamsBuilder builder =
new StoreProcParamsBuilder()
.WithOutParam <string>("bar")
.WithOutParam <int>("foo");
StoredProcParam[] parameters = builder.Build();
// Act
ProcResponse result = databaseApi.CallStoredProcAsync <ProcResponse>("foo", "dataset", parameters).Result;
// Assert
result.Foo.ShouldBe(123);
result.Bar.ShouldBe("test");
result.Dataset.Count.ShouldBe(2);
result.Dataset.Any(x => x.FirstName == "Selena").ShouldBe(true);
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync(null, parameters));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>(null, parameters));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>(null, "dataset", parameters));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>("foo", null, parameters));
}
public void ShouldCallStoredProcWithoutParametersAsync()
{
// Arrange
IDatabaseApi databaseApi = CreateDatabaseApi();
// Act & Assert
databaseApi.CallStoredProcAsync <ProcResponse>("foo", "dataset").Wait();
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync(null));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>(null));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>(null, "dataset"));
Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredProcAsync <ProcResponse>("foo", (string)null));
}
public void ShouldCallStoredProcAsync()
{
// Arrange
IDatabaseApi databaseApi = CreateDatabaseApi();
IStoreProcParamsBuilder builder =
new StoreProcParamsBuilder()
.WithOutParam <string>("bar")
.WithOutParam <int>("foo");
StoredProcParam[] parameters = builder.Build();
// Act
ProcResponse result = databaseApi.CallStoredProcAsync <ProcResponse>("foo", "dataset", parameters).Result;
// Assert
result.foo.ShouldBe(123);
result.bar.ShouldBe("test");
result.dataset.Count.ShouldBe(2);
result.dataset.Any(x => x.first_name == "Selena").ShouldBe(true);
}
