public DBParameter(string parametername, AHKDbType datatype, ParameterDirection direction, object value) { this.parameterName = parametername; this.oracleDbtype = getEquivalentOracleDbType(datatype); this.parameterDirection = direction; this.value = (value != null) ? value : DBNull.Value; }
private OracleDbType getEquivalentOracleDbType(AHKDbType type) { switch (type) { case AHKDbType.BFile: return(OracleDbType.BFile); case AHKDbType.Blob: return(OracleDbType.Blob); case AHKDbType.Byte: return(OracleDbType.Byte); case AHKDbType.Char: return(OracleDbType.Char); case AHKDbType.Clob: return(OracleDbType.Clob); case AHKDbType.Date: return(OracleDbType.Date); case AHKDbType.Decimal: return(OracleDbType.Decimal); case AHKDbType.Double: return(OracleDbType.Double); case AHKDbType.Int16: return(OracleDbType.Int16); case AHKDbType.Int32: return(OracleDbType.Int32); case AHKDbType.Int64: return(OracleDbType.Int64); case AHKDbType.IntervalDS: return(OracleDbType.IntervalDS); case AHKDbType.IntervalYM: return(OracleDbType.IntervalYM); case AHKDbType.Long: return(OracleDbType.Long); case AHKDbType.LongRaw: return(OracleDbType.LongRaw); case AHKDbType.NChar: return(OracleDbType.NChar); case AHKDbType.NClob: return(OracleDbType.NClob); case AHKDbType.NVarchar2: return(OracleDbType.NVarchar2); case AHKDbType.Raw: return(OracleDbType.Raw); case AHKDbType.RefCursor: return(OracleDbType.RefCursor); case AHKDbType.Single: return(OracleDbType.Single); case AHKDbType.TimeStamp: return(OracleDbType.TimeStamp); case AHKDbType.TimeStampLTZ: return(OracleDbType.TimeStampLTZ); case AHKDbType.TimeStampTZ: return(OracleDbType.TimeStampTZ); case AHKDbType.Varchar2: return(OracleDbType.Varchar2); case AHKDbType.XmlType: return(OracleDbType.XmlType); default: return(OracleDbType.Varchar2); } }