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

Firefox and Chrome dark mode

Dealing with the morons who built Dell 7710 and RAID