Stored Procedure Mapping for Insert using function

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ksyme99
Posts: 1
Joined: Thu 13 Jun 2013 10:29

Stored Procedure Mapping for Insert using function

Post by ksyme99 » Thu 13 Jun 2013 10:33

Hello,

I am trying to map a function on my Oracle database to an insert stored procedure. I have found it works fine when it doesn't return anything but I need it to return some basic data. Since it's a function which returns a scalar value, I cannot bind the column to the property, since the column name can't be found in the results. Is there a way to bind a function result using this? Or will I need to use an out parameter?

Ken

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

Re: Stored Procedure Mapping for Insert using function

Post by Shalex » Tue 18 Jun 2013 07:46

1. Are you using EDM Wizard (ADO.NET Entity Data Model, *.edmx) or Entity Developer (Devart Entity Model, *.edml)? We recommend using Entity Developer: http://www.devart.com/entitydeveloper/ed-vs-edm.html.
2. Specify versions of your Visual Studio and dotConnect for Oracle.
3. Send us your test model and the DDL script of the function and related database objects.

Post Reply