Function Mapping in dotConnect for Postgres

MLaiss · Post by **MLaiss** » Fri 01 Oct 2010 22:52

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

AndreyR · Post by **AndreyR** » Tue 26 Oct 2010 14:34

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.

AndreyR · Post by **AndreyR** » Thu 03 Mar 2011 16:31

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.