Lazycoder

SqlConnectionStringBuilder use the Data Link

SqlConnectionStringBuilder

Bill Ryan mentions the new SqlConnectionStringBuilder in ADO.NET 2.0. I’ll probably end up using it in code once it arrives, but I’m not very impressed by it. I can never remember the order those things go in or the exact syntax either, same way with all of the damn window.open options in the browser DOM. So I’ve used a shortcut to create my connection strings. I create a new DataLink file and open it in EditPlus (any text editor will do).

I don’t remember where I first heard about this, but there’s an article from waaaaay back in 2000 that explains how to do this.