Another Entity Framework Function problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
TonyV
Posts: 74
Joined: Wed 25 May 2011 15:03

Another Entity Framework Function problem

Post by TonyV » Thu 03 Nov 2011 19:28

I have created 2 new stored functions in my postgres database:

Code: Select all

CREATE OR REPLACE FUNCTION tracking."CurrentVersion"() RETURNS BIGINT
AS $$
	SELECT currval('tracking."Versions_From_seq"'::regclass);
$$ LANGUAGE Sql;

CREATE OR REPLACE FUNCTION tracking."NextVersion"() RETURNS BIGINT
AS $$
    SELECT nextval('tracking."Versions_From_seq"'::regclass);
$$ LANGUAGE Sql;
I have updated my Entity Model to include these functions. When I try to create a method for either of them, I get the following error message:

Code: Select all

Cannot create method for a storage funtion 'CurrentVersion' that can be composed.  Only stored procedures may be mapped.
I have tried checking off "Concealed Function" in the function editor dialog, but this doesn't stayed checked. When I open the editor again, the check mark is gone.

How do I add these functions to my model?

Tony

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

Post by Shalex » Fri 04 Nov 2011 16:31

TonyV wrote:I have tried checking off "Concealed Function" in the function editor dialog, but this doesn't stayed checked. When I open the editor again, the check mark is gone.
We have reproduced this bug and will post here when it is fixed.

As a temporary workaround, please set "Concealed Function" to True in the Properties window (select function in strore part in Model Explorer and press F4).

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

Post by Shalex » Wed 09 Nov 2011 16:00

The bug with setting the Concealed Function property in Stored Procedure Editor is fixed. We will notify you when the corresponding build of dotConnect for PostgreSQL is available for download.

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

Post by Shalex » Fri 11 Nov 2011 17:07

New build of dotConnect for PostgreSQL 5.50.244 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22545 .

Post Reply