internal static OracleType DbTypeToOracleType(DbType dbType) {
switch (dbType) {
case DbType.AnsiString : return OracleType.VarChar;
case DbType.Binary : return OracleType.Blob;
case DbType.Byte : return OracleType.Byte;
case DbType.Boolean : return OracleType.Byte;
case DbType.Currency : return OracleType.Number;
case DbType.Date : return OracleType.DateTime;
case DbType.DateTime : return OracleType.DateTime;
case DbType.Decimal : return OracleType.Number;
case DbType.Double : return OracleType.Double;
case DbType.Guid : return OracleType.Char;
case DbType.Int16 : return OracleType.Int16;
case DbType.Int32 : return OracleType.Int32;
case DbType.Int64 : return OracleType.Number;
case DbType.Object : return OracleType.Cursor;
case DbType.SByte : return OracleType.SByte;
case DbType.Single : return OracleType.Float;
case DbType.String : return OracleType.VarChar;
case DbType.Time : return OracleType.Timestamp;
case DbType.UInt16 : return OracleType.UInt16;
case DbType.UInt32 : return OracleType.UInt32;
case DbType.UInt64 : return OracleType.Number;
case DbType.VarNumeric : return OracleType.Number;
case DbType.AnsiStringFixedLength : return OracleType.NChar;
case DbType.StringFixedLength : return OracleType.Char;
default : throw ExceptionHelper.InvalidDbType((int)dbType);
}
}