private static string GetConnectionStringTemplate(
string servername,
string database,
string username,
string password,
bool trusted
)
{
const string applicationName = "SQL Server Diagnostic Script Runner";
const string trustedConnectionStringTemplate = "Server={0};Database={1};Trusted_Connection=True;Application Name={2}";
const string sqlLoginConnectionStringTemplate = "Server={0};Database={1};User Id={2};Password={3};Application Name={4}";
if (trusted)
{
return string.Format(trustedConnectionStringTemplate, servername, database, applicationName);
}
return string.Format(sqlLoginConnectionStringTemplate, servername, database, username, password, applicationName);
}