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); } } }