Stored Procedure Parameter Direction Detection
Posted: Mon 04 Jun 2018 13:03
Hi,
I've imported two stored procedures from an existing database. Entity Developer recognized the parameters marked as output as output parameters for the model. But output parameters in MS SQL Server are always inout parameters. When I change them in the Entity Feveloper model by hand, everything is great. As soon as I compare against the database, then it shows up that the parameters on the database are output only parameters (which can't be existing on MS SQL Server...).
MS SQL Server 2016
EF Core 2.0
Entity Developer 6.2.505
https://stackoverflow.com/questions/124 ... eter-issue
Best Regards
Helmut
I've imported two stored procedures from an existing database. Entity Developer recognized the parameters marked as output as output parameters for the model. But output parameters in MS SQL Server are always inout parameters. When I change them in the Entity Feveloper model by hand, everything is great. As soon as I compare against the database, then it shows up that the parameters on the database are output only parameters (which can't be existing on MS SQL Server...).
MS SQL Server 2016
EF Core 2.0
Entity Developer 6.2.505
https://stackoverflow.com/questions/124 ... eter-issue
Best Regards
Helmut