Just a quick recommendation to anyone fed up of writing long-winded Data Access Layers. Take a moment to check out Subsonic. Subsonic Download Page
Subsonic takes a lot of the time out of Data Access development by generating a DAL for you, all you need to do is specify the connection to your database and voila you get strongly typed access to your database tables (or indeed Stored Procedures).
I’ve found it speeds up development of the mundane code you otherwise find yourself writing over and over, and enables you to focus on the more important issues (your business logic).
Definitely worth a look and the latest version (currently in beta) is just around the corner.