protected override DbParameter CreateDbParameter( )
{
var parameter = new MemoryDbParameter( );
Parameters.Add(parameter);
return(parameter);
}
private void AddVariable(MemoryDbCommand command, SqlVariableDeclareStatement variableDeclaration)
{
foreach (var declaration in variableDeclaration.Declarations)
{
var column = new Column(null, declaration.Name, declaration.Type, UserDataTypes, 1);
var variable = new MemoryDbParameter
{
ParameterName = column.Name,
DbType = column.DbDataType,
NetDataType = column.NetDataType,
Precision = ( byte )column.Precision,
Scale = ( byte )column.Scale,
Size = column.Size,
IsNullable = true
};
command.Variables.Add(variable);
}
}
public void AddParameters(MemoryDbCommand command, SqlParameterDeclarationCollection parameterDeclarations)
{
if (parameterDeclarations != null)
{
foreach (var parameterDeclaration in parameterDeclarations)
{
var column = new Column(null, parameterDeclaration.Name, parameterDeclaration.Type, UserDataTypes, 1);
var parameter = new MemoryDbParameter
{
ParameterName = column.Name.TrimStart(new [] { '@' }),
DbType = column.DbDataType,
NetDataType = column.NetDataType,
Precision = ( byte )column.Precision,
Scale = ( byte )column.Scale,
Size = column.Size,
IsNullable = true
};
command.Parameters.Add(parameter);
}
}
}
