public void SetOracleParameterCommandPlSqlAssociativeArray(IDbCommand cmd, IOracleParameterRetretreiver retreiver)
{
testObject.Add("Foo", collectionType: OracleMappingCollectionType.PLSQLAssociativeArray);
testObject.AddParam(cmd);
cmd.Parameters.Should().HaveCount(1);
var param = retreiver.GetParameter(cmd.Parameters[0]);
param.CollectionType.Should().Be("PLSQLAssociativeArray");
}
public void SetOracleParameter(IDbCommand cmd, IOracleParameterRetretreiver retreiver)
{
testObject.Add("Foo", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.ReturnValue);
testObject.AddParam(cmd);
cmd.Parameters.Should().HaveCount(1);
var param = retreiver.GetParameter(cmd.Parameters[0]);
param.OracleDbType.Should().Be("RefCursor");
param.ParameterName.Should().Be("Foo");
}
public void Works_On_Decorated_Commands(IDbCommand command, IOracleParameterRetretreiver retreiver)
{
var parameters = new TestableOracleDynamicParameters();
parameters.Add("Foo", dbType: OracleMappingType.RefCursor, direction: ParameterDirection.ReturnValue);
parameters.AddParam(command);
var oracleParam = retreiver.GetParameter(command.Parameters[0]);
oracleParam.OracleDbType.Should().Be("RefCursor");
oracleParam.Direction.Should().Be(ParameterDirection.ReturnValue);
}
public void ArrayBindSizeSet_ValueIsSet(IDbCommand cmd, IOracleParameterRetretreiver retreiver)
{
var bindSizeArray = Enumerable.Range(0, 20).ToArray();
testObject.Add("Foo", "Bar", arrayBindSize: bindSizeArray);
testObject.AddParam(cmd);
cmd.Parameters.Should().HaveCount(1);
var param = retreiver.GetParameter(cmd.Parameters[0]);
param.ParameterName.Should().Be("Foo");
param.Value.Should().Be("Bar");
param.ArrayBindSize.Should().BeSameAs(bindSizeArray);
}
public void SetAllProperties(IDbCommand cmd, IOracleParameterRetretreiver retreiver)
{
testObject.Add("Foo", "Bar", OracleMappingType.Varchar2, ParameterDirection.Input, 42, true, 0, 0, "MySource", DataRowVersion.Original);
testObject.AddParam(cmd);
cmd.Parameters.Should().HaveCount(1);
var param = retreiver.GetParameter(cmd.Parameters[0]);
param.ParameterName.Should().Be("Foo");
param.Value.Should().Be("Bar");
param.OracleDbType.Should().Be("Varchar2");
param.Direction.Should().Be(ParameterDirection.Input);
param.Size.Should().Be(42);
param.IsNullable.Should().Be(true);
param.Scale.Should().Be(0);
param.Precision.Should().Be(0);
param.SourceColumn.Should().Be("MySource");
param.SourceVersion.Should().Be(DataRowVersion.Original);
}
