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     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0