public async Task ExecuteSpWithParametersWithOneResult_Correct()
{
var configs = new StoredProcedureConfiguration
{
ConnectionString = Constants.ConnectionString,
StoredProcedureName = "usp_test",
StoredProcedureParameters = new Dictionary <string, object>()
{
{ "@status", 1 },
{ "@boolean", true },
}
};
var response = await _operations.ExecuteStoredProcedureAsync(configs, async (results) =>
{
return(await results.Read(async() => new SpResponse
{
Test = await results.GetColumnValue <string>("test"),
Status = await results.GetColumnValue <int>("status"),
Boolean = await results.GetColumnValue <bool>("boolean"),
}));
});
Assert.Equal("hello", response.Test);
Assert.Equal(1, response.Status);
Assert.True(response.Boolean);
}