NET Data Access Architecture Guide Configure the stored procedure and embedded SQL comparison: Reasons for using stored procedures: Security, the user must obtain a license to access the stored procedure. 3. The stored procedure is more easily maintained: and the embedded code and the SQL statement that has been deployed to the client is more easily maintained. 4. The stored procedure provides a higher Abstract: The client is isolated outside the specific implementation details. 5. Storage procedures can reduce network failures because you can batch, not multiple requests from the client.
The stored procedure is actually the "transaction script" mode in the << Enterprise Application Schema (Personal View)
The view in the book: In the case of business logic, use the "things script" mode to build a business application quickly. But SQL is structured after all, and the abstract ability and complex is limited, When the business logic is complex, the transaction script is difficult to adapt, and the repeated script is often common, and it has become difficult to maintain.
Therefore, the author is still aware of "domain model"
