Are two SQL Server Connection Strings equal?


using System.Data.SqlClient;



public static bool AreEqual(string connectionString1, string connectionString2)
        {
            SqlConnectionStringBuilder connection1 = new SqlConnectionStringBuilder(connectionString1);
            SqlConnectionStringBuilder connection2 = new SqlConnectionStringBuilder(connectionString2);
 
            if ((connection1.InitialCatalog.ToLower() == connection2.InitialCatalog.ToLower() ||
                 connection1.AttachDBFilename.ToLower() == connection2.AttachDBFilename.ToLower()) &&
                connection1.DataSource.ToLower() == connection2.DataSource.ToLower())
            {
                return true;
            }
            else
            {
                return false;
            }
        }

Comments

Popular posts from this blog

Enable Visual Studio to use more than 2GB of memory

Firefox and Chrome dark mode

Dealing with the morons who built Dell 7710 and RAID