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; } }