Running Postgres stored procedure with C#

Question

I created a stored procedure stocks.public.daily_actions_full() that not receive or return something, it just inserts data from a view to a table.

After using using dbcontext scaffold all the tables and views were added except the stored procedures.

I saw that it's a known issue and the option to call stored procedures is to use ExecuteSqlCommand.

I tried the following code:

using (var db = new stocksContext())
{
    var rowsAffected = db.Database.ExecuteSqlCommand("CALL stocks.public.daily_actions_full()");
}

But I'm getting the following error:

Not sure what I'm missing here or if there's another way to call stored procedures.

Maybe adding it to the context file manually? (Couldn't find how)

Thanks!

Answer 1

As @Alexander Petrov wrote here:
Use ExecuteSqlRaw to solve it.
Thanks everyone for your help.