I searched ... I see a lot of benefits, but it seems that all the benefits stem from the built-in SQL comparison. I know that SQL online is bad. But why compare with the bad to show another better?
If stored procedures are used (possibly exclusively), it seems that none of the benefits exist. Stored procedures definitely provide performance benefits in terms of security, performance (if ORM can bypass the stored procedure, then the stored procedure is poorly written), and a well-written stored procedure is an automatic repository (template). Stored procedures can definitely provide better control over transactions and transactions.
I am very grateful for the answer - how ORM is better over a well-designed application using stored procedures.
--- Thanks for all the answers I get so far ... It looks like the benefits are still related to mapping ORM usage of “dynamically generated SQL” using “statically written embedded SQL” in the code. Yes, this has its advantages. But that is not a question.
The question is better worded as follows:
If you think that stored procedures for implementing your business logic (SP can be written very advanced, as well as very efficiently), in the application code (.NET, JAVA) you have a very thin shell layer of stored procedures organized by business needs . My question is how ORM comes out of this architecture (of course, well-designed).
ORM OO. , , SQL, .
. , :
1) ORM - . 2) Procs - - . - /. 3) ORM , , - - , , ORM, , ORM .
- ORM , - , .
, ( ) . , ORM , .
ORM - , , " ". , , , SQL/Stored , .
, - ( ++, # Java), . , , , "-" OO , ORM .
:
DataSet
, , , , , , . , , . ORM ( / ORM) (, ) , ORM, , ( , Spring.NET Entity Framework, ).
ORM ? . , ORM? . , ORM? , .
, . , SQL / , ORM ? - - , ? , , ORM .