shan nathan

shan nathan

  • NA
  • 64
  • 28.1k

Best Way to call stored procedure from c#

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