Page 1 of 1

Supporting issue for Oracle Data Types (BFILE, ORDIMAGE)

Posted: Tue 27 Oct 2009 06:05
by abhinay_agrawal
Hi,
I am using

dotConnect for Oracle 5.25 Professional Trial and
Ora_developerTools2.55forVisual_studio2008

as per stated in product features

All Oracle data types support

I tried to use it with following table in Entity Framework

Name Null? Type
----------------------------------------- -------- ----------------------------
EMPID NOT NULL VARCHAR2(30)
EMPDETAILS CLOB
EMPIMAGE BLOB
EMPRESUME NCLOB
DOC LONG RAW
JOININGDATE TIMESTAMP(6)
EMPIMAGEBFILE BINARY FILE LOB
IMG ORDIMAGE


while populating entity from Oracle database we are getting warning message as

The data type "BFILE" is not supported

also getting same for ORDIMAGE

and those EMPIMAGEBFILE, IMG fields not populating into the Entity Class.

(Oracle Database 10g Enterprise Edition Release 10.1.0.2.0)

Is it a bug??

Please let me know dotconnect for oracle is supporting for BFILE as well as ORDIMAGE datatypes or not?


Thanks,
Abhinay.
[/img]

Posted: Tue 27 Oct 2009 14:46
by AndreyR
Our ADO.NET provider supports all Oracle data types.
But Entity Framework support does not provide the possibility to support all Oracle-specific types,
in particular, Object types are not supported.

Posted: Wed 28 Oct 2009 13:41
by abhinay_agrawal
Thank you AndreyR for your quick reply.