Mimer SQL Data Provider help
How to convert from Oracle Data Provider
Mimer SQL Data Provider > Overview > Converting an application to Mimer SQL Data Provider > How to convert from Oracle Data Provider

To convert an existing Oracle Data Provider application based on ADO.NET to the Mimer SQL Data Provider you need to take the following steps:

  1. Replace all occurrences of Oracle.DataAccess.Client with Mimer.Data.Client. This includes both using clauses and references that use full names.

  2. Locate all references to OracleDbType and decide how to map these. The table below gives guidelines for data type mapping.

  3. Replace all object references with prefix Oracle to prefix Mimer, which is used by the Mimer SQL Data Provider.

  4. Recompile your application. When you recompile the application you may discover that there are Oracle specific functions that are used by the application. You must consider how to handle these.

  5. In the ConnectionString property of the MimerConnection object, choose the desired data source. The Oracle connection string properties should be converted to the appropriate Mimer connection string properties.

  6. Test your application thoroughly.


 

OracleType Corresponding MimerDbType

BFile

An Oracle BFILE data type that contains a reference to binary data with a maximum size of 4 gigabytes that is stored in an external file.

Blob

Blob

An Oracle BLOB data type that contains binary data with a maximum size of 4 gigabytes.

Blob

Byte

An integral type representing unsigned 8-bit integers with values between 0 and 255.

No corresponding type, use DbType.Byte.

Char

An Oracle CHAR data type that contains a fixed-length character string with a maximum size of 2,000 bytes.

Char or NChar

Clob

An Oracle CLOB data type that contains character data, based on the default character set on the server, with a maximum size of 4 gigabytes.

Clob

Date

An Oracle DATE data type that contains a fixed-length representation of a date and time, ranging from January 1, 4712 BC. to December, 31, 4712 AD., with the default format dd-mmm-yy.

Date

Decimal

A fixed precision and scale numeric value with 38 digits precision.

Decimal

Double

A double-precision floating-point value.

Double

Int16

An integral type representing signed 16-bit integers with values between -32768 and 32767.

SmallInt

Int32

An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647.

Int

Int64

A 64-bit signed integer.

BigInt

IntervalDS

An Oracle INTERVAL DAY TO SECOND data type (Oracle 9i or later) that contains an interval of time in days, hours, minutes, and seconds, and has a fixed size of 11 bytes.

IntervalDayToSecond

IntervalYM

An Oracle INTERVAL YEAR TO MONTH data type (Oracle 9i or later) that contains an interval of time in years and months, and has a fixed size of 5 bytes.

IntervalYearToMonth

Long

An Oracle LONG data type that contains a variable-length character string with a maximum size of 2 gigabytes.

Clob

LongRaw

An Oracle LONGRAW data type that contains variable-length binary data with a maximum size of 2 gigabytes.

Blob

NChar

An Oracle NCHAR data type that contains fixed-length character string to be stored in the national character set of the database, with a maximum size of 2,000 bytes (not characters) when stored in the database. Note: The size of the value is dependent on the national character set of the database. See your Oracle documentation for more information.

NChar

NClob

An Oracle NCLOB data type that contains character data to be stored in the national character set of the database, with a maximum size of 4 gigabytes (not characters) when stored in the database. Note: The size of the value is dependent on the national character set of the database. See your Oracle documentation for more information.

NClob

NVarChar2

An Oracle NVARCHAR2 data type that contains a variable-length character string stored in the national character set of the database, with a maximum size of 4,000 bytes (not characters) when stored in the database. Note: The size of the value is dependent on the national character set of the database. See your Oracle documentation for more information.

NVarChar

Raw

An Oracle RAW data type that contains variable-length binary data with a maximum size of 2,000 bytes.

VarBinary

RefCursor

An Oracle REF CURSOR.

No corresponding type.

Single

A single-precision floating-point value.

Real

Timestamp

An Oracle TIMESTAMP (Oracle 9i or later) that contains date and time (including seconds), and ranges in size from 7 to 11 bytes.

Timestamp. Use the .NET Framework DateTime data type.

TimestampLTZ

An Oracle TIMESTAMP WITH LOCAL TIMEZONE (Oracle 9i or later) that contains date, time, and a reference to the original time zone, and ranges in size from 7 to 11 bytes.

Timestamp . Use the .NET Framework DateTime data type.

TimestampTZ

An Oracle TIMESTAMP WITH TIMEZONE (Oracle 9i or later) that contains date, time, and a specified time zone, and has a fixed size of 13 bytes.

Timestamp.Use the .NET Framework DateTime data type.

VarChar2

An Oracle VARCHAR2 data type that contains a variable-length character string with a maximum size of 4,000 bytes.

VarChar or NVarChar
See Also