To SP or Not to SP

We spent a lot of time discussing how to build a custom DAL, and then we concluded that for a Domain Model pattern, using a O/R mapping layer is the only way to go. We also concluded that a well-built DAL is like a simple O/R mapper. Ten years ago, the scenario was radically different.

The best and fastest computers in a company used to be those equipped with a DBMS. Object-orientation was still in its infancy as far as the Microsoft platform was concerned. (C# was the first easy-to-use, object-oriented language we had from Microsoft, and it came along in 2002.) Envisioning a system as "a database with some business code around" was an excellent approach. And we built quite a few systems that way. Stored procedures were by far ...

Get Microsoft® .NET: Architecting Applications for the Enterprise now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.