protected internal sealed override void SetParameterDbType(ResultSet res) { int dataType = res.getInt("DATA_TYPE"); SqlDbType = SqlConvert.JdbcTypeToSqlDbType(dataType); JdbcType = dataType; }
protected override int GetProviderType(int jdbcType) { return((int)SqlConvert.JdbcTypeToSqlDbType(jdbcType)); }
// Gets an Object that is a representation of the underlying SqlDbType Variant. public Object GetSqlValue(int columnIndex) { try { int jdbcType = ResultsMetaData.getColumnType(columnIndex + 1); SqlDbType sqlDbType = SqlConvert.JdbcTypeToSqlDbType(jdbcType); switch (sqlDbType) { case SqlDbType.BigInt: return(GetSqlInt64(columnIndex)); case SqlDbType.Binary: return(GetSqlBinary(columnIndex)); case SqlDbType.Bit: return(GetSqlBoolean(columnIndex)); case SqlDbType.Char: return(GetSqlString(columnIndex)); case SqlDbType.DateTime: return(GetSqlDateTime(columnIndex)); case SqlDbType.Decimal: return(GetSqlDecimal(columnIndex)); case SqlDbType.Float: return(GetSqlDouble(columnIndex)); case SqlDbType.Image: return(GetSqlBinary(columnIndex)); case SqlDbType.Int: return(GetSqlInt32(columnIndex)); case SqlDbType.Money: return(GetSqlDecimal(columnIndex)); case SqlDbType.NChar: return(GetSqlString(columnIndex)); case SqlDbType.NText: return(GetSqlString(columnIndex)); case SqlDbType.NVarChar: return(GetSqlString(columnIndex)); case SqlDbType.Real: return(GetSqlSingle(columnIndex)); case SqlDbType.UniqueIdentifier: return(GetSqlGuid(columnIndex)); case SqlDbType.SmallDateTime: return(GetSqlDateTime(columnIndex)); case SqlDbType.SmallInt: return(GetSqlInt16(columnIndex)); case SqlDbType.SmallMoney: return(GetSqlDecimal(columnIndex)); case SqlDbType.Text: return(GetSqlString(columnIndex)); case SqlDbType.Timestamp: return(GetSqlDateTime(columnIndex)); case SqlDbType.TinyInt: return(GetSqlByte(columnIndex)); case SqlDbType.VarBinary: return(GetSqlBinary(columnIndex)); case SqlDbType.VarChar: return(GetSqlString(columnIndex)); case SqlDbType.Variant: return(GetValue(columnIndex)); default: return(GetValue(columnIndex)); } } catch (SQLException exp) { throw new Exception(exp.Message); } }