EDML model and procedure with input parameter of type TABLE

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
McMlok
Posts: 26
Joined: Tue 04 Jun 2013 13:01

EDML model and procedure with input parameter of type TABLE

Post by McMlok » Wed 11 Dec 2013 09:52

Hi all,

does anybody knows how to add procedure to EF model when procedure has one input parameter of type TABLE? When I import procedure from DB I obtain error "The Type TABLE is not qualified with a namespace or alias. Only primitive types can be used without qualification."

Thank's

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

Re: EDML model and procedure with input parameter of type TABLE

Post by Shalex » Thu 12 Dec 2013 12:34

Non-primitive types are not supported in Entity Framework. The list of primitive types is available at http://msdn.microsoft.com/en-us/library/ee382832.aspx.

In case of OUT TABLE parameters, you can reconstruct your procedure to return Oracle cursor instead. The way how to work with REF CURSORs is described at our blog: http://blog.devart.com/working-with-sto ... rsors.html.

In case of IN TABLE parameters, please employ a plain ADO.NET code: http://forums.devart.com/viewtopic.php?f=1&t=25027.

Post Reply