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 ShouldBuildWithInParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithInParam("name", 123); // Assert StoredProcParam param = builder.Build().First(); param.Name.ShouldBe("name"); param.Type.ShouldBe("integer"); param.ParamType.ShouldBe("IN"); param.Value.ShouldBe("123"); }
public void ShouldBuildWithInParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithInParam("name", 123); // Assert StoredProcParam param = builder.Build().First(); param.name.ShouldBe("name"); param.type.ShouldBe("integer"); param.param_type.ShouldBe("IN"); param.value.ShouldBe("123"); }
public void ShouldBuildWithOutParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithOutParam<bool>("name", 100); // Assert StoredProcParam param = builder.Build().First(); param.Name.ShouldBe("name"); param.Type.ShouldBe("boolean"); param.ParamType.ShouldBe("OUT"); param.Value.ShouldBe(null); param.Length.ShouldBe(100); }
public void ShouldBuildWithInOutParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithInOutParam("name", "value", 100); // Assert StoredProcParam param = builder.Build().First(); param.Name.ShouldBe("name"); param.Type.ShouldBe("string"); param.ParamType.ShouldBe("INOUT"); param.Value.ShouldBe("value"); param.Length.ShouldBe(100); }
public void ShouldBuildWithOutParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithOutParam <bool>("name", 100); // Assert StoredProcParam param = builder.Build().First(); param.name.ShouldBe("name"); param.type.ShouldBe("boolean"); param.param_type.ShouldBe("OUT"); param.value.ShouldBe(null); param.length.ShouldBe(100); }
public void ShouldBuildWithInOutParam() { // Arrange IStoreProcParamsBuilder builder = new StoreProcParamsBuilder(); // Act builder.WithInOutParam("name", "value", 100); // Assert StoredProcParam param = builder.Build().First(); param.name.ShouldBe("name"); param.type.ShouldBe("string"); param.param_type.ShouldBe("INOUT"); param.value.ShouldBe("value"); param.length.ShouldBe(100); }
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); }
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); }
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)); }