Composite type in oracle table not working in entity framework

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Praveen140
Posts: 1
Joined: Mon 29 Aug 2016 05:21

Composite type in oracle table not working in entity framework

Post by Praveen140 » Mon 29 Aug 2016 06:02

Hello

I am using Devart 8.5 pro version in my application. I have my tables in oracle which are using Composite data type for some of my columns. For example my table Admin_Fee has one of the column "Percentage" which has Type defined as "Data_TY". When I build my model using the database first through entity framework I am getting the below error message:

The column 'Percentage' has unsupported data type 'Data_TY'. Cannot create class for entity 'Admin_Fee'.

Is there any way I can use the composite type columns of my oracle table in the entity framework?

Thanks

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Composite type in oracle table not working in entity framework

Post by Shalex » Mon 29 Aug 2016 17:25

Entity Framework supports only primitive types: http://msdn.microsoft.com/en-us/library/ee382832.aspx. From the Entity Framework's point of view, composite types are not primitive. The list of supported types in Oracle is available at https://www.devart.com/dotconnect/oracl ... pping.html.

Post Reply