2
Reply

Best Way to call stored procedure from c#

shan nathan

shan nathan

Mar 23 2015 2:17 AM
766
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)