public void TableValueParameterWithoutReturnTypeStoredProcedure_CallsCorrectly()
{
// 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 }
};
var parameters = new TableValueParameterWithoutReturnTypeStoredProcedure.Parameter
{
TvpParameters = itemsToAdd
};
var procedure = new TableValueParameterWithoutReturnTypeStoredProcedure(parameters);
// ACT
Connection.ExecuteStoredProcedure(procedure);
// ASSERT
}
public void SqlParameters_WhenSuppliedTableValueParameters_HasCorrect()
{
// ARRANGE
const SqlDbType expectedSqlDbType = SqlDbType.Structured;
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 }
};
var parameters = new TableValueParameterWithoutReturnTypeStoredProcedure.Parameter
{
TvpParameters = itemsToAdd
};
// ACT
var sqlParameterBuilder = new SqlParametersFromObjectPropertiesBuilder<TableValueParameterWithoutReturnTypeStoredProcedure.Parameter>(parameters);
sqlParameterBuilder.BuildSqlParameters();
var sqlParameters = sqlParameterBuilder.SqlParameters.ToList();
var actual = sqlParameters[0];
// ASSERT
Assert.AreEqual(expectedSqlDbType, actual.SqlDbType);
}
