private static void showConnectionStringAndShortestConnectionString(string connectionString)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder(connectionString);
connectionString = connectionStringBuilder.ConnectionString;
string shortestConnectionString = SqlConnectionStringBuilderHelper.ShortestConnectionString(connectionStringBuilder);
Console.WriteLine(connectionString);
Console.WriteLine(shortestConnectionString);
Console.WriteLine();
}
static void Main(string[] args)
{
// a few examples of ConnectionStrings from http://connectionstrings.com/sql-server-2008#p1 and their shortened forms.
showConnectionStringAndShortestConnectionString("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");
showConnectionStringAndShortestConnectionString("Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;");
showConnectionStringAndShortestConnectionString(@"Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;");
showConnectionStringAndShortestConnectionString(@"Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;");
showConnectionStringAndShortestConnectionString("Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;");
showConnectionStringAndShortestConnectionString("Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; MultipleActiveResultSets=true;");
showConnectionStringAndShortestConnectionString(@"Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname; Trusted_Connection=Yes;");
showConnectionStringAndShortestConnectionString(@"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;");
showConnectionStringAndShortestConnectionString(@"Data Source=.\SQLExpress;Integrated Security=true; AttachDbFilename=|DataDirectory|\mydb.mdf;User Instance=true;");
showConnectionStringAndShortestConnectionString("Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;");
showConnectionStringAndShortestConnectionString("Server=myServerAddress;Database=myDataBase;Integrated Security=True;Asynchronous Processing=True;");
// the HTML table of equivalent keys
IEnumerable <string> keys = SqlConnectionStringBuilderHelper.Keys;
IEnumerable <string> orderedKeys = keys.OrderBy(s => s); // http://stackoverflow.com/a/3630693/29290
DataTable dataTable = new DataTable();
dataTable.Columns.Add("Key");
dataTable.Columns.Add("ShortesEquivalentKey");
dataTable.Columns.Add("EquivalentKeys");
foreach (string key in orderedKeys)
{
string shortestEquivalentKey = SqlConnectionStringBuilderHelper.ShortestEquivalentKey(key);
List <string> equivalentKeys = SqlConnectionStringBuilderHelper.EquivalentKeys(key);
string equivalentKeysCSV = AsCSV(equivalentKeys);
dataTable.Rows.Add(key, shortestEquivalentKey, equivalentKeysCSV);
}
string htmlTable = AsHtmlTable(dataTable);
Console.WriteLine(htmlTable);
Console.ReadLine();
}