public static OracleDbType GetType(MDBType type)
        {
            switch (((int)type))
            {
            case 1:
                return(OracleDbType.Int16);

            case 2:
                return(OracleDbType.Date);

            case 3:
                return(OracleDbType.Decimal);

            case 4:
                return(OracleDbType.Int64);

            case 5:
                return(OracleDbType.NVarchar2);

            case 6:
                return(OracleDbType.Varchar2);

            case 7:
                return(OracleDbType.Blob);

            case 8:
                return(OracleDbType.NClob);
            }
            throw new Exception();
        }
        /// <summary>
        /// Bool = 1,
        /// Date = 2,
        /// Decimal = 3,
        /// Int = 4,
        /// NVarChar = 5,
        /// VarChar = 6
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
#if POSTGRESQL
        public static NpgsqlDbType GetType(MDBType type)
        {
            switch (((int)type))
            {
            case 1:
                return(NpgsqlDbType.Boolean);

            case 2:
                return(NpgsqlDbType.Date);

            case 3:
                return(NpgsqlDbType.Numeric);

            case 4:
                return(NpgsqlDbType.Integer);

            case 5:
                return(NpgsqlDbType.Text);

            case 6:
                return(NpgsqlDbType.Varchar);

            case 7:
                return(NpgsqlDbType.Bytea);

            case 8:
                return(NpgsqlDbType.Text);
            }
            throw new Exception();
        }
        public static SqlDbType GetSqlType(MDBType type)
        {
            switch (((int)type))
            {
            case 1:
                return(SqlDbType.Int);

            case 2:
                return(SqlDbType.DateTime);

            case 3:
                return(SqlDbType.Decimal);

            case 4:
                return(SqlDbType.Int);

            case 5:
                return(SqlDbType.NVarChar);

            case 6:
                return(SqlDbType.VarChar);

            case 7:
                return(SqlDbType.Blob);

            case 8:
                return(SqlDbType.NClob);
            }
            throw new Exception();
        }
Exemple #4
0
        public MDBParameter Add(string paraName, MDBType MdbType, int size, string sourceColumn)
        {
            MDBParameter parameter = null;

            try
            {
                #if POSTGRESQL
                parameter = new MDBParameter(((NpgsqlParameterCollection)this.paramCols).Add(paraName, MDBGetType.GetType(MdbType), size, sourceColumn));
                #else
                parameter = new MDBParameter(((OracleParameterCollection)this.paramCols).Add(paraName, MDBGetType.GetType(MdbType), size, sourceColumn));
                #endif
            }
            catch (Exception exception)
            {
                parameter = null;
#if POSTGRESQL
                throw new MDBException(exception, exception.Message);
#else
                OracleException ex = (OracleException)exception;
                throw new MDBException(exception, exception.Message, ex.Number);
#endif
            }
            return(parameter);
        }