Devart Forums

Hello, one of my requirement is using Oracle and SQL server and being able to switch providers based on client's install base (sql server or oracle).

Does your Oracle provider support data types like .Net GUID?, boolean?

It is important to understand that we will use only .Net data types. we want to be unaware of the database running below the EF provider we will use.


Does devart provide a solution in this regard?

DotConnect for Oracle supports both System.Guid and System.Boolean data types. NUMBER(1) columns in the EDM Wizard are automatically mapped to System.Boolean. The support for the Guid to RAW(16) is manual for the time being: open the model with XML Editor, and change the type "RAW" to "guid" in the SSDL model part, and the "Binary" type for "Guid" type in the CSDL model part.
EDM Wizard also supports automatical column mapping to Int32, Int64, Double, Decimal, String, DateTime, TimeSpan, Byte[], but still there is no support for System.SByte, System.Byte, System.Int16, System.Single, System.DataTimeOffset.
As for the EDM Wizard, the support of these types is not well grounded, but we are working on the new flexible solution of this and other mapping tasks.