Unable to execute stored procedure with entityframework 6 and Npgsql 3.0.5

[roji]

From @awaynemd on February 29, 2016 6:11

As posted on stackoverflow, I get

An exception of type 'System.Data.Entity.Core.EntityCommandCompilationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: An error occurred while preparing the command definition. See the inner exception for details.

Inner Exception is: {"Value does not fall within the expected range."}

I suspect the problem is with NpgsqlServices.TranslateCommandTree, but I'm only guessing.

Will this be fixed anytime soon?

Copied from original issue: npgsql/npgsql#983

[roji]

From @awaynemd on March 7, 2016 5:29

Additional information: The above error was generated in entity framework 6.0 with Npgsql 3.0.5:

public string SayHello()
{
            using (var ctx = new chaosEntities())
            {
                var x = ctx.sayhello();
                return x;
            }
}

[roji]

Not sure this is supposed to work... Does anyone know if this is supported with SqlServer?

[akusmin]

Greetings, Please give an update. Is there any option to use db functions? I have similar issue within Npgsql.NpgsqlServices.TranslateCommandTree()

Thanks

[dkabracadabra]

See #38