public void AddParameters(int index, string paramName, StoredProcedureParameterDirection parameterDirection, DbType type, int size) { //if (this.providerType == DataProvider.Oracle) //{ // OracleParameter param = new OracleParameter(paramName, OracleType.Cursor); //} if (index < idbParameters.Length) { idbParameters[index].ParameterName = paramName; idbParameters[index].DbType = type; idbParameters[index].Size = size; switch (parameterDirection) { case StoredProcedureParameterDirection.Input: idbParameters[index].Direction = System.Data.ParameterDirection.Input; break; case StoredProcedureParameterDirection.Output: idbParameters[index].Direction = System.Data.ParameterDirection.Output; break; case StoredProcedureParameterDirection.InputOutput: idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput; break; case StoredProcedureParameterDirection.ReturnValue: idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue; break; } } }
public void AddParameters(int index, string paramName, object objValue, StoredProcedureParameterDirection parameterDirection, DbType dbType, int size) { if (index < idbParameters.Length) { idbParameters[index].ParameterName = paramName; idbParameters[index].Value = objValue; idbParameters[index].Size = size; idbParameters[index].DbType = dbType; switch (parameterDirection) { case StoredProcedureParameterDirection.Input: idbParameters[index].Direction = System.Data.ParameterDirection.Input; break; case StoredProcedureParameterDirection.Output: idbParameters[index].Direction = System.Data.ParameterDirection.Output; break; case StoredProcedureParameterDirection.InputOutput: idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput; break; case StoredProcedureParameterDirection.ReturnValue: idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue; break; } } }
public void AddParameters(int index, string paramName, StoredProcedureParameterDirection parameterDirection) { if (index < idbParameters.Length) { idbParameters[index].ParameterName = paramName; switch (parameterDirection) { case StoredProcedureParameterDirection.Input: idbParameters[index].Direction = System.Data.ParameterDirection.Input; break; case StoredProcedureParameterDirection.Output: idbParameters[index].Direction = System.Data.ParameterDirection.Output; break; case StoredProcedureParameterDirection.InputOutput: idbParameters[index].Direction = System.Data.ParameterDirection.InputOutput; break; case StoredProcedureParameterDirection.ReturnValue: idbParameters[index].Direction = System.Data.ParameterDirection.ReturnValue; break; } } }
public StoredProcedureParameter( string parameterName, ColumnType parameterType, object defaultValue, StoredProcedureParameterDirection direction) { this.ParameterName = parameterName; this.ParameterType = parameterType; this.DefaultValue = defaultValue; this.Direction = direction; }
protected StoredProcedureSchema AddParameter(string parameterName, ColumnType parameterType, object defaultValue = null, StoredProcedureParameterDirection direction = StoredProcedureParameterDirection.IN) { this.Parameters[parameterName] = new StoredProcedureParameter(parameterName, parameterType, defaultValue, direction); return(this); }