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:

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

Reference

MimerDbType Enumeration