public void TableValueParameterStoredProcedureWithReturnAndEmptyList_DoesNotThrowException()
{
// ARRANGE
var itemsToAdd = new List<SimpleParameterTableType>();
int expectedCount = itemsToAdd.Count;
var parameters = new TableValueParameterWithReturnTypeStoredProcedure.Parameter
{
TvpParameters = itemsToAdd
};
var procedure = new TableValueParameterWithReturnTypeStoredProcedure(parameters);
// ACT
var results = Connection.ExecuteStoredProcedure(procedure);
var actualCount = results.Count;
// ASSERT
Assert.IsNotNull(results);
Assert.AreEqual(expectedCount, actualCount);
}
public void TableValueParameterStoredProcedureWithReturn_CallsCorrectlyAndReturnsValues()
{
// ARRANGE
var itemsToAdd = new List<SimpleParameterTableType>
{
new SimpleParameterTableType { Name = "Company 1", IsActive = true, Id = 2 },
new SimpleParameterTableType { Name = "Company 2", IsActive = false, Id = 2 },
new SimpleParameterTableType { Name = "Company 3", IsActive = true, Id = 2 }
};
int expectedCount = itemsToAdd.Count;
var parameters = new TableValueParameterWithReturnTypeStoredProcedure.Parameter
{
TvpParameters = itemsToAdd
};
var procedure = new TableValueParameterWithReturnTypeStoredProcedure(parameters);
// ACT
var results = Connection.ExecuteStoredProcedure(procedure);
var actualCount = results.Count;
// ASSERT
Assert.IsNotNull(results);
Assert.AreEqual(expectedCount, actualCount);
}
