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?