public void ShouldCallStoredFuncAsync() { // Arrange IDatabaseApi databaseApi = CreateDatabaseApi(); IStoreProcParamsBuilder builder = new StoreProcParamsBuilder() .WithOutParam <string>("bar") .WithOutParam <int>("foo"); StoredProcParam[] parameters = builder.Build(); // Act ProcResponse result = databaseApi.CallStoredFuncAsync <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.CallStoredFuncAsync <ProcResponse>(null, parameters)); Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredFuncAsync <ProcResponse>(null, "dataset", parameters)); Should.Throw <ArgumentNullException>(() => databaseApi.CallStoredFuncAsync <ProcResponse>("foo", null, parameters)); }
public void ShouldCallStoredFuncAsync() { // Arrange IDatabaseApi databaseApi = CreateDatabaseApi(); IStoreProcParamsBuilder builder = new StoreProcParamsBuilder() .WithOutParam <string>("bar") .WithOutParam <int>("foo"); StoredProcParam[] parameters = builder.Build(); // Act ProcResponse result = databaseApi.CallStoredFuncAsync <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); }