Dofactory.com
Dofactory.com
 Back to list
Views:   12.2K
Replies:  2
Archived

How to use stored procedures with Design Pattern Framework?

Hello,

In the ADO.NET part of your Design Pattern Framework the sql is created inline and sent to the database.

I am using Stored Procedures.  How do I make a generic method to pass just the stored procdure name and parameters required for those procedures in the Db.cs class in the data access layer?

I look forward to some coding guidance.

Thanks.



Abhishek Ranjan, May 07, 2011
Reply 1
Thanks...Will try that and get back if i am stuck anywhere.
Abhishek Ranjan, May 16, 2011
Reply 2
You need to change the functions of Db.cs file, Instead of passing the string sql as parameter pass the storedprocedure name,
& set the command.CommandType as storedprocedure.
SANDEEP PANDEY, May 12, 2011
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.