Using SqlCommand with SP and without SP Parameteres but just Values in C#

Question

Hi it's possible to use the SQLCommand to work with Stored Procedures but without the need of specify the name of each parameter?

We have always to have the names of SP variables in some collection (like array of strings) to work with the SP?

The common use is this:

sqlComm.Parameters.Add("@name_SP_variable", "some_value");

What i mean if it's possible to do something like this:

sqlComm.Parameters.Add("some_value");

If we just send the right number of parameters and in the right order, can't we just put the values without the name of the variables of the SP?

Can you guarantee that your code and database will always 100% be in sync and nobody will ever accidentally change the order of either the parameters in code or in the stored proc? I'd put the parameter names in. — Joe
– Joe, Commented Apr 26, 2011 at 3:31

Community · Accepted Answer · 2017-05-23 12:29:05Z

1

Take a look at SqlCommand.DeriveParameters(). This post has an example usage.

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Apr 26, 2011 at 2:58

Bala R

109k23 gold badges203 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Miguel Over a year ago

But doing is a good or a bad idea? I am just asking this because if it's the better way, so we always need to have some collection with all Names of SP Parameters...

Bala R Over a year ago

I'm not very familiar with stored procedures. Maybe someone else will comment on it.

Joel Lee Over a year ago

@Miguel Are you trying to automatically generate the parameters for your SQL command? I'm a bit confused by your statement that "we need to have a collection with the names." Normally, when you construct the SQL command in your C# code, you know the names of the parameters or can easily look them up. That is, the names of the parameters are in your head as you write your code.

Collectives™ on Stack Overflow

Using SqlCommand with SP and without SP Parameteres but just Values in C#

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related