Page 1 of 1

Function Mapping in dotConnect for Postgres

Posted: Fri 01 Oct 2010 22:52
by MLaiss
In the helpfile for dotConnect for postgres I can't read anything about function mapping for insert/update/delete operations for a entity.

So is it possible with dotConnect for postgres? And when so, can you give me an example?

How I have to declare the output of a function when I want to use Result Column Binding in Entity developer?

Thanks

Posted: Tue 26 Oct 2010 14:34
by AndreyR
It is not possible with the help of the out parameters - Entity Framework does not support procedures with out parameters in the mapping behaviour.
We will investigate if it's possible to implement a workaround using the refcursor return type or the RowsAffected parameter. I will post here as soon as any new information is available.

Posted: Thu 03 Mar 2011 16:31
by AndreyR
We have added this functionality.
The solution is to write a function returning the id of the inserted record (for example) and then create a result binding with the "return_value" name. The generated ID will be passed to the entity correctly.