>Just curious, is there a requirement to do it at the framework level? Are you not able to implement stored procedures in the database?

Yes, but the framework handles a lot of events and this is for code and platform evolution, including any possibilty of a backend changes from one of the application supported by it such as if a client would like to switch from SQL Server to Oracle, thus the requirement to be able to do it by simply changing the connection string.