+ 2

Linkq vs store procedures which one better?

Please some detail advantage linkq and store procedures.

26th Nov 2019, 2:52 AM
Vannak Saing
Vannak Saing - avatar
4 Respuestas
+ 4
Linq runs in your application layer and stored procedures run in the database. Deciding where to put such logic, may also depend on the particular task. If the code is tightly associated with your data model and data representation, a stored procedure may be ok. I think from maintenance point of view, putting any non-static logic of data transformation and manipulation, is easier to deal with in the application level (meaning I would probably prefer LINQ most of the time).
26th Nov 2019, 5:23 AM
Tibor Santa
Tibor Santa - avatar
+ 3
True. In addition to Tibor I personally like to keep it in code. Because then I know who is maintaining it. But if you maintain both Program code and Database. A stored procedure is also a good option. Sometimes when the program is at a customer side. A stored procedure is preferred. It can give a "educated" customer (read : database administrator) some flexibility, because they can make minor changes to the stored procedure without the need of recompiling your the program. They do not need to contact you with a change request.
26th Nov 2019, 9:25 PM
sneeze
sneeze - avatar
+ 2
Thank you so much! For answer.😚
9th Dec 2019, 2:58 AM
Vannak Saing
Vannak Saing - avatar
+ 1
with you ever hacker please check your program yes next you hacker you can.t out ? me out next 1day see you!
9th Dec 2019, 3:39 PM
ali(asghar)javadi