private static string GetRoleUserName(DbRoles role)
{
switch (role)
{
case DbRoles.sa_admin:
return("sa");
default:
return(Convert.ToString(role));
}
}
private static string GetRolePassword(DbRoles role)
{
switch (role)
{
case DbRoles.sa_admin:
return("whitehouse");
default:
return(Convert.ToString(role) + "1!");
}
}
public static string BuildMyConnectionString(string encServerName, string encDbName, DbRoles role = DbRoles.xrm_user, string appName = "EmailBlast")
{
try
{
return(string.Format(SqlConnStringFormat, encServerName, encDbName, GetRoleUserName(role), GetRolePassword(role), appName));
}
catch (Exception ex)
{
throw ex;
}
}
