Monday, June 10, 2019

If we an architecture of stored procedures, why not also introduce Database-first Entity Framework?

  1. Whenever a sproc is called for CRUD functionality it should be logged and we would have to roll our own logging if we are sidestepping the sprocs.
  2. When we face a security audit we would have to argue our case for why our database interactions are secure whilst instead the security of the sprocs would be unburdened from us and on the DBA's shoulders.
  3. A hodgepodge will be confusing.

No comments:

Post a Comment