private void SetupConnectionString()
{
SystemInfo.SQLConnectionSettings ConnectionSettings = SystemInfo.GetSQLConnectionSettings();
ConnectionString = String.Format("Server={0};Uid={1};Password={2};Allow Batch=true;Treat Tiny As Boolean=false",
ConnectionSettings.Server,
ConnectionSettings.User,
ConnectionSettings.Password,
ConnectionSettings.Schema);
//
// If a dedicated connection is not in use, prepend the database
// with a USE statement to slightly increase performance.
//
if (Dedicated == false)
{
ConnectionString += ";Max Pool Size=3;Pooling=true";
this.DatabaseName = ConnectionSettings.Schema;
this.QueryPrepend = String.Format("USE {0}; ", DatabaseName);
}
else
{
//
// Explicitly set the database for a dedicated connection.
//
ConnectionString += String.Format(";Database={0}", ConnectionSettings.Schema);
}
}