Many of the apps I have written need to target multiple databases or I want the connection to be configurable by the user. I have a user control in my common library that I use all the time to let the user connect to a database.

You will need the Sql Management Objects from http://www.microsoft.com/Downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en to compile the demo project.

I also make use of http://umbrella.codeplex.com/ and http://www.codeplex.com/clinq in my common libraries, it should be quite simple to remove the dependencies on these two libraries if you wanted to. The first library adds a heap of really useful extension methods, like AddRange to collections that More >