Supporting issue for Oracle Data Types (BFILE, ORDIMAGE)

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
abhinay_agrawal
Posts: 9
Joined: Wed 07 Oct 2009 14:09

Supporting issue for Oracle Data Types (BFILE, ORDIMAGE)

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 9
Joined: Wed 07 Oct 2009 14:09

Post by abhinay_agrawal » Wed 28 Oct 2009 13:41

Thank you AndreyR for your quick reply.

Post Reply