When I think of sources for information on application architecture, I rarely think MSDN Library, but I did find the article on Designing Data Tier Components and Passing Data Through Tiers for .Net applications to be full of useful information and design considerations.