general question regarding EF support

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 1
Joined: Fri 28 Nov 2008 22:11

general question regarding EF support

Post by kirkt » Fri 28 Nov 2008 22:14

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?

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 01 Dec 2008 08:20

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.

Post Reply