Devart Forums

Very useful information. Thank You.

Is trial and error the only way to find out what entity framework data types are supported in this oracle data provider?

Is there a current Compatibility Table for Oracle Data Types to .NET Entity Column Data Types? Does this already exist in the forums or on the Visual Studio help files?

I'd like to build my Oracle database with Compatible Data Types for easy mapping in the designer or by manual editing of the CSDL/SSDL. I'd like a reference for developing my database.

I noticed that some data mappings from oracle to entity columns have been added and may change over time(e.g Int16) and that some other datatypes may not be supported?

What I'd be looking for is something like:
(don't expect this to be correct for current devart compatibility)
[.NET: boolean] = [oracle: NUMBER(1)] Mapping = Designer and Manual
[.NET: boolean] = [oracle: BYTE(1)] Mapping = Manual Only
[.NET: Int32] = [oracle: NUMBER(*,0)] Mapping = Designer and Manual
[.NET: Int64] = [oracle: NUMBER(*,0)] Mapping = Designer and Manual
[.NET: Double] = [oracle: NUMBER(*,*)] Mapping = Designer and Manual
[.NET: Double] = [oracle: FLOAT] Mapping = Designer and Manual
[.NET: String] = [oracle: VARCHAR2(*)] Mapping = Designer and Manual
[.NET: String] = [oracle: NVARCHAR2(*)] Mapping = Manual Only
[.NET: Guid] = [oracle: RAW(16)] Mapping = Manual Only
[.NET: DateTimeOffset] = Unsupported

Examples needed
[.NET: Binary]
[.NET: Boolean]
[.NET: Byte]
[.NET: DateTime]
[.NET: DateTimeOffset]
[.NET: Decimal]
[.NET: Double]
[.NET: Guid]
[.NET: Int16]
[.NET: Int32]
[.NET: Int64]
[.NET: SByte]
[.NET: Single]
[.NET: String]
[.NET: Time]

I'd also like to know if there is a "preferred" oracle type that might be more compatible or closer to the matching data types that could provide the best performance by requiring the least conversion computation needed.

Regards,
DS