Paul Wilson On OR/M vs. SP
In an exceptionally written post, Paul Wilson drives at least a couple of wedges into the OR/M vs. SP arguments. Perhaps it is good that we are having the same conversation every four months or so, so far there have been at least a couple of new points brought up that I haven’t seen before.
The most interesting part in Paul’s post was when he talks about SP for security in the face of connection pooling. Since most application will use a single connection string to access the database, in order to utilize connection pooling, the security provided by stored procedures is meaningless. All the users of the applications map to the same user in the database. All with the same permissions.