C# Entity Framework using PostgreSQL, NPGSQL and stored procedures returning a table result parameter errors

Question

Using .Net Framework 4.5, Entity Framework 6.0.0.0, and NPGSQL, I am trying to update the model from the database and use a stored procedure that returns a table result from a PostgeSQL stored procedure (function).

I am getting an error for each column that comes from the stored procedure that states the column

... has a parameter direction value 'null', which is not valid. Please use 'IN', 'OUT', or 'INOUT'

From my understanding of PostgreSQL, when returning a table, you don't specify IN or OUT.

Is there a workaround for this or am I missing a setting, etc for .Net or PostgreSQL?

René Vogt · Accepted Answer · 2016-03-05 20:36:49Z

0

=> Your definition:

Create function xpto (p1 integer, p2 varchar)
RETURNS TABLE (a int, b int) ...

=> Change the definition

Create function xpto (IN p1 integer, IN p2 varchar, OUT a int, OUT b int)
RETURNS SETOF record

edited Mar 5, 2016 at 20:36

René Vogt

44.1k15 gold badges84 silver badges106 bronze badges

answered Mar 5, 2016 at 20:25

Alexandre Assi

16

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# Entity Framework using PostgreSQL, NPGSQL and stored procedures returning a table result parameter errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related