Supporting issue for Oracle Data Types (BFILE, ORDIMAGE)

abhinay_agrawal · Post by **abhinay_agrawal** » Tue 27 Oct 2009 06:05

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]

AndreyR · Post by **AndreyR** » Tue 27 Oct 2009 14:46

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.

abhinay_agrawal · Post by **abhinay_agrawal** » Wed 28 Oct 2009 13:41

Thank you AndreyR for your quick reply.