Stored procedure generic function

Question

1.00/5 (1 vote)

See more:

Good Day all

Can anyone please tell me how i can create a c sharp function that will execute all my stored procedures throughout my app. i want to do it in such a way that when i need to execute a stored procedure all i do is invoke the c sharp function and pass it some parameters.

thanks
Regards

Posted 16-Feb-13 19:40pm

Georges23

Updated 16-Feb-13 20:12pm

v2

Add a Solution

Comments

Sandeep Mewara 17-Feb-13 1:48am

Does not make much sense. SP's are executed once you trigger. Invoke function, trigger SP... if needed, SP inside SP..
Now what is the question?

Georges23 17-Feb-13 2:11am

no i mean invoking stored procedures inside c sharp generic function

Georges23 17-Feb-13 2:12am

please read the updated version of my question

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-02-16T20:15:00

It's not strictly possible to write a generic method that will "execute all my stored procedures" for the simple reason that the procedures will have different parameters which must be supplied and a generic routine will have no idea what information to pass in these parameters.

However, you can make a method for each procedure manually. If you mark it as static, it would be available throughout your app via a static MyClass.MyMethod call.

**Zoltán Zörgő** · Answer 2 · 2013-02-16T20:24:00

If "generic" here is the OO term - than the question makes no sense, since the SP not in the scope of c#.
If "generic" means "capable of handling any SP", than you might consider not struggling with this, since it would be too complex.
The approach you can see here: http://kennyshu.blogspot.hu/2008/10/generic-method-for-getting-data-from-db.html[^] is handling only one scenario of retrieving results, but you can use it to make suitable for your needs. But believe me, you will not gain much.

Stored procedure generic function

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0