0

I have two stored procedure with "same name" but different functionality in different database.

Suppose I have two database named DB1 & DB2. In DB1 stored procedure contains 7 parameteres and DB2 contains 11 parameters.

So how can i get stored procedure parameteres count using C#. By using Count I can add condition for both different databases.

Suhaib Janjua
  • 3,452
  • 14
  • 56
  • 72
Amit Kumar
  • 1,051
  • 3
  • 21
  • 43
  • possible duplicate of [How can I retrieve a list of parameters from a stored procedure in SQL Server](http://stackoverflow.com/questions/33761/how-can-i-retrieve-a-list-of-parameters-from-a-stored-procedure-in-sql-server) – Steve Mar 06 '14 at 09:41
  • 1
    I am using session for getting connection string.using nhibernate ORM – Amit Kumar Mar 06 '14 at 09:43

1 Answers1

0

Following links will help you,

http://www.4guysfromrolla.com/articles/092408-1.aspx

http://adamprescott.net/2012/09/21/sqlcommandbuilder-deriveparameters/

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/getting-the-list-of-parameters/

any help let me know...............

prabhakaran S
  • 708
  • 1
  • 6
  • 12