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:
Replace all occurrences of Oracle.DataAccess.Client with Mimer.Data.Client. This includes both using clauses and references that use full names.
Locate all references to OracleDbType and decide how to map these. The table below gives guidelines for data type mapping.
Replace all object references with prefix Oracle to prefix Mimer, which is used by the Mimer SQL Data Provider.
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.
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.
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 |