Geek asks and answers

Can write a DAL parameter set from a stored procedure?

Is there a way that I can get the parameter collection code in C # that will be used in the DAL by running the stored procedure? please, help.

+3
source share
1 answer

Take a look at SqlCommandBuilder.DeriveParameters(). (It also works in the latest Oracle drivers)

It will load the parameters from the stored procedure into the property of .Parametersyour DbCommand object, and you can foreach()skip them to get names, types and directions ...

Hope you were looking ...

+4
source

More articles:


All Articles