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

To convert an existing Oracle application based on Microsoft's data provider for ADO.NET to the Mimer SQL Data Provider you need to take the following steps:

  1. Replace all occurrences of System.Data.OracleClient with Mimer.Data.Client. This includes both using clauses and references that use full names.
  2. Locate all references to OracleType 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

Cursor

An Oracle REF CURSOR.

No corresponding type.

DateTime

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

Double

A double-precision floating-point value.

Double

Float

A single-precision floating-point value.

Real

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

IntervalDayToSecond

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

IntervalYearToMonth

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

LongRaw

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

Blob

LongVarChar

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

Clob

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

Number

An Oracle NUMBER data type that contains variable-length numeric data with a maximum precision and scale of 38.

Decimal

NVarChar

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

RowId

The base64 string representation of an Oracle ROWID data type.

No corresponding type.

SByte

An integral type representing signed 8 bit integers with values between -128 and 127.

SmallInt or DbType.SByte

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.

TimestampLocal

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.

TimestampWithTZ

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.

UInt16

An integral type representing unsigned 16-bit integers with values between 0 and 65535.

No corresponding type, use DbType.UInt16.

UInt32

An integral type representing unsigned 32-bit integers with values between 0 and 4294967295.

No corresponding type, use DbType.UInt32.

VarChar

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