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
EDML model and procedure with input parameter of type TABLE
Re: EDML model and procedure with input parameter of type TABLE
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.
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.