/* * Params use native values now, this is unnecessary * public static Alphora.Dataphor.DAE.Runtime.Data.DataValue DataValue(Schema.IDataType AType, object AValue, DAECommand ACommand) * { * if (AValue == null) * return null; * return Alphora.Dataphor.DAE.Runtime.Data.DataValue.FromNative(((DAEConnection)ACommand.Connection).ServerProcess, AType, AValue); * } */ internal string Prepare(string commandText, DAECommand command) { if (commandText.IndexOf(ParameterName) > -1) { DataParam runtimeParam = null; if (command.DAERuntimeParams.IndexOf(ParameterName) < 0) { if ((Direction == ParameterDirection.Output) || (Direction == ParameterDirection.ReturnValue)) { runtimeParam = new DataParam(ParameterName, DataTypeFromDAEDbType(_type, (DAEConnection)command.Connection), Modifier(Direction)); } else { runtimeParam = new DataParam(ParameterName, DataTypeFromDAEDbType(_type, (DAEConnection)command.Connection), Modifier(Direction), _value); } command.DAERuntimeParams.Add(runtimeParam); } else { runtimeParam = command.DAERuntimeParams[ParameterName]; if ((Direction != ParameterDirection.Output) && (Direction != ParameterDirection.ReturnValue)) { runtimeParam.Value = _value; } } } return(commandText); }
protected internal DAEDataReader(IServerCursor cursor, DAECommand command) { _cursor = cursor; _command = command; // Cache native types _nativeTypes = new ArrayList(); foreach (TableVarColumn column in _cursor.Plan.TableVar.Columns) { _nativeTypes.Add(GetNativeType(column.DataType, column, _cursor.Plan.Process.DataTypes)); } }
public virtual object Clone() { DAECommand newInstance = new DAECommand(); newInstance.CommandText = _commandText; newInstance.CommandType = _commandType; newInstance.UpdatedRowSource = _updatedRowSource; foreach (DAEParameter param in _parameters) { newInstance.Parameters.Add(param.Clone()); } newInstance.Connection = _connection; newInstance.Transaction = _transaction; newInstance.CommandTimeout = _commandTimeout; return(newInstance); }
/// <summary> /// Initializes a new instance of the DAEDataAdapter class with the /// specified D4 select statement. /// </summary> /// <param name="selectCommand">D4 select statement.</param> public DAEDataAdapter(DAECommand selectCommand) { SelectCommand = selectCommand; }
/// <summary> /// Initializes a new instance of the DAEDataAdapter class with an D4 select statement and a DAEConnection object. /// </summary> /// <param name="selectCommandText">D4 select statement.</param> /// <param name="connection">The DAE connection</param> public DAEDataAdapter(string selectCommandText, DAEConnection connection) { SelectCommand = new DAECommand(selectCommandText, connection); }
/// <summary> /// Initializes a new instance of the DAEDataAdapter class with an D4 select statement and a connection string. /// </summary> /// <param name="selectCommandText">D4 select statement.</param> /// <param name="selectConnectionString"></param> public DAEDataAdapter(string selectCommandText, string selectConnectionString) { SelectCommand = new DAECommand(selectCommandText, new DAEConnection(selectConnectionString)); }
/// <summary> /// A special reader that returns 1 for records affected. /// When records affected is required for an execute statement. /// </summary> /// <param name="command"></param> protected internal DAEDataReader(DAECommand command) { _command = command; _rowCount = 1; //Records effected is always one when the reader is in a non-cursor. _nativeTypes = new ArrayList(); }
public DAEParameterCollection(DAECommand command) : base() { _command = command; _items = new List <DAEParameter>(); }