EDML model and procedure with input parameter of type TABLE

EDML model and procedure with input parameter of type TABLE

Postby 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
McMlok
 
Posts: 20
Joined: Tue 04 Jun 2013 13:01

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

Postby 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-stored-procedures-and-ref-cursors.html.

In case of IN TABLE parameters, please employ a plain ADO.NET code: http://forums.devart.com/viewtopic.php?f=1&t=25027.
Shalex
Devart Team
 
Posts: 7782
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle