As an extension to this(referenced at the connection string link above), I utilize the Microsoft Data Link(UDL) file to simplify connection strings (or to make changing them not involve any changes to the actual code.
Provider is missing the above Developer Fusion wizard.
hey Peso, what do you mean? It's assuming you're using the SqlConnection object (either directly or via Linq/NHibernate/Entity Framework) so you wouldn't ever need to specify the provider as such? (unless I'm missing something!)
If there is a problem, do let me know and we'll get it fixed. Thanks