2
Answers

Best Way to call stored procedure from c#

shan nathan

shan nathan

9y
1.7k
1
Hi there,
  Hope all are fine....
  Here i want to know some information from you.  There are two ways to call stored procedure from c# (as far as i know).
1. create a commandtype.storedprocedure and assign sp name to that. 
Then add parameter and call.
2. Create a command that contains (call sp_name(?,?,?)) and assign parameter value to '?' and execute.
 
I want to know which is best way means which will give fastest output return.... pls help me...
 
 Thanks in advance... 
Answers (2)