Why use/need Store Procedures of PLSQL in C#

Question

0.00/5 (No votes)

See more:

Hi,

I have one Quotation. So many function are available(function,methods) in C# or any language. Why use/need Store Procedures/function of database?

Posted 30-Jan-14 2:18am

omgade

Add a Solution

Comments

SP HINGU 30-Jan-14 8:24am

http://www.seguetech.com/blog/06/04/Advantage-drawbacks-stored-procedures-processing-data

5 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 · 2014-01-30T02:31:00

There are a number of reasons:
1) It "focusses" procedures so they are easier to use in more than one application. For example, if a company uses a customer reference which is built from several fields, possibly in more than one table, then a Stored Procedure allows that to be done in one place, and called from several location - since they all use the same DB, they all use the same SP, and it makes it more reliable. Equally, it can return info as if it came from a single table whereas in reality it is retrieved from several via a complicated set of JOINs.
2) It can reduce bandwidth and / or processing use in transferring information from the DB to the application: if the processing is all done inside SQL then it can devise an execution plan that reflects the way it is being used. If you pull the same data back to the app, then you may well be retrieving information you don't need and wasting time that way.

There is a balance here: some things are good candidates for SP, others are best done locally. It's not a simple "use them for this" (or even "use them for everything" as some will probably tell you!).

Alexander Dymshyts · Answer 2 · 2014-01-30T04:52:00

Solution 3

I would like to add that Linq cannot update views. So for that you also would like to use sp. Yes, there are some tricks, but I prefer to use sp in this cases

Posted 30-Jan-14 4:52am

Alexander Dymshyts

Updated 30-Jan-14 4:55am

v2

Jörgen Andersson · Answer 3 · 2014-01-30T07:43:00

As an addition to Griffs comments:
3) They decouple your business logic from the database, you can make changes in the database and change the SP to reflect them, and the business logic would never need to know.
4) Safety, this is as far as I'm concerned the single most important reason. You can have a separate set of access rights to the stored procedures and have an extra user for your applications that only can use a set of stored procedures. So if for example your webpage gets hacked you have limited what kind of damage the hacker can do in the database.

ZurdoDev · Answer 4 · 2014-01-30T02:25:00

Solution 1

Stored procedures are the way you interact with the database. PSQL does not understand the C# language so you need to write your INSERTS, UPDATES, DELETES, SELECTS, etc in Psql first. Then you use C# to interact your application with PSQl.

Posted 30-Jan-14 2:25am

ZurdoDev

Gitanjali Singh · Answer 5 · 2014-01-30T17:34:00

Solution 5

Refer:
Overview of SQL Server Stored Procedure[^]
http://www.aspdotnet-suresh.com/2011/07/what-is-stored-procedure-in-sql-server.html[^]
This may answer your question.

Posted 30-Jan-14 17:34pm

Gitanjali Singh

Updated 30-Jan-14 17:35pm

v2