Listing 2, Accessing Connection Strings Reliably
Dim cn As String
cn = New ConnectionManager.Northwind
The ConnectionManager class would look like this:
Public Class ConnectionManager
Public ReadOnly Property Northwind As String
Get
Return System.Web.Configuration.WebConfigurationManager. _
ConnectionStrings("Northwind").ConnectionString
End Get
End Class
About the Author
Peter Vogel is a system architect and principal in PH&V Information Services. PH&V provides full-stack consulting from UX design through object modeling to database design. Peter tweets about his VSM columns with the hashtag #vogelarticles. His blog posts on user experience design can be found at http://blog.learningtree.com/tag/ui/.