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:

[![error](https://i.stack.imgur.com/RX6RW.png)](https://i.stack.imgur.com/RX6RW.png)

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!