public override void ExecuteCommand()

in Source/NuGetGallery.Operations/Tasks/Database/DeleteSqlUserTask.cs [33:72]

39 lines of code
7 McCabe index (conditional complexity)


        public override void ExecuteCommand()
        {
            WithConnection((c, db) =>
            {
                foreach (var user in Users)
                {
                    if (db.Query<string>("SELECT name FROM sys.database_principals WHERE name = @n", new { n = user }).Any())
                    {
                        if (!WhatIf)
                        {
                            db.Execute(String.Format("DROP USER [{0}]", user));
                        }
                        Log.Info("Deleted Database User: {0}", user);
                    }
                    else
                    {
                        Log.Info("No DB User found: {0}", user);
                    }
                }
            });

            WithMasterConnection((c, db) =>
            {
                foreach (var user in Users)
                {
                    if (db.Query<string>("SELECT name FROM sys.sql_logins WHERE name = @n", new { n = user }).Any())
                    {
                        if (!WhatIf)
                        {
                            db.Execute(String.Format("DROP LOGIN [{0}]", user));
                        }
                        Log.Info("Deleted SQL Login: {0}", user);
                    }
                    else
                    {
                        Log.Info("No SQL Login found: {0}", user);
                    }
                }
            });
        }