Recently a colleague of mine introduced me to an amazing technology. Subsonic is a tool that integrates closely with Visual Studio 2005 and will generate an object model for your database at compile time based on the database connection in your web.config.
This greatly simplifies your code as all the connection logic, proc calls with types etc all disappear into a couple lines of code. Its amazing. You should really look into it. I have provided a couple links here to get you started.\\
Here is the main site for the project: http://www.subsonicproject.com/
You will also want the tools that integrate with Visual Studio 2005 available at:
If you have any cool links about subsonic post comments here with them or email them to me at email@example.com or firstname.lastname@example.org