The answer *so* depends on your development environment. If I was starting a brand new system or application today, all middle-tier business logic would be in a DLL with...
-----------------------
Scripted
SQL Server user and admin since v2000
"It takes a village to raise a SQL Server."