I've come accross this these articles which i think are
a must read before starting to design any kind of a serious application

Designing and building a robust data access layer
Managing SQL exceptions in .NET applications

Very nice.