At 12/27/2004 12:19 PM (Monday), Peter Welch wrote:

>SQL is such a bear to program in. Despite the great advances in OOP,
>we're back to murky SQL procedural programming to implement a .NET
>solution -- if what I read is correct, that one should use stored
>procedures for all database activity. IOW, all business logic is being
>put back in the database.

Except that you are subject to the DB server's anaemic stored procedure
language and the fact that it is proprietary to each RDBMS!

Actually, I think the preferred solution is to create an application server
between the app and the DB. Have this app server talk objects to the app
and SQL to the data store. The extra layer always seems to add complexity
but the simplified interfaces and increased modularity win out in the end!