Another Entity Framework Function problem
Posted: Thu 03 Nov 2011 19:28
I have created 2 new stored functions in my postgres database:
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:
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
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;
Code: Select all
Cannot create method for a storage funtion 'CurrentVersion' that can be composed. Only stored procedures may be mapped.
How do I add these functions to my model?
Tony