Imports System.Data.SqlClient Imports System.Data Public Class DataServices Public Shared Function ConnectToDB() As SqlConnection Dim Conn As SqlConnection Dim ConnString As String ConnString = ConfigurationSettings.AppSettings("ConnectionString") If ConnString Is Nothing OrElse ConnString.Length = 0 Then ' use a default conn string is no one is found in config ConnString = "server=(local);database=adefaultdbperhaps;trusted_connection=yes" End If Try Conn = New SqlConnection(ConnString) Conn.Open() Catch ex As Exception Conn = Nothing End Try Return Conn End Function End Class>I am not using Mere Mortals.NET (yet!), but I am using the business object in the Hentzenwerke book. Right now, I have the database connection string hard-coded in the BusinessObject base class. Is it a better idea to put this in the web.config file? That seems to be what I am reading so far as best practices. If so, then should I set the connection string from web.config in the BusinessObject constructor method?
>public BusinessObject() >{ > this.strConnectionString = ConfigurationSettings.AppSettings("constring"); >} >