I am trying to convince a colleague that we should move our app's business logic that currently resides in stored procedures to Csharp/VB code behind for the upcoming rewrite of one of our ancient ASP classic applications.
Would you please share your knowledge of advantages and disadvantages to storing business logic in the code behind instead of stored procedures?
The main advantages I see to using the code behind as the business logic layer are (in no particular order):
1) ease of debugging business layer logic - this can be done at compile time
2) ease of maintainability (touches on advantage 1)
3) re-usability - encapsulation of classes that can easily be reused.