Linkq vs store procedures which one better?

Question

Please some detail advantage linkq and store procedures.

Answer 1

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).

Answer 2

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.

Answer 3

Thank you so much! For answer.😚

Answer 4

with you ever hacker please check your program yes next you hacker you can.t out ? me out next 1day see you!