reExp.Controllers.rundotnet.SqlServerUtils.DoShrinkJob C# (CSharp) Method

        public void DoShrinkJob()
        {
            try
            {
                string sql = @"select sum(size/128) from [rextester].[sys].[database_files]";
                using (SqlConnection conn = new SqlConnection(GlobalUtils.TopSecret.SqlServerCS))
                using (SqlCommand command = new SqlCommand(sql))
                {
                    conn.Open();
                    command.Connection = conn;
                    int sizeInMb = Convert.ToInt32(command.ExecuteScalar());

                    if (sizeInMb > 100)
                    {
                        sql = @"DBCC SHRINKDATABASE(N'rextester' )";
                        using (SqlCommand command2 = new SqlCommand(sql))
                        {
                            command2.Connection = conn;
                            command2.ExecuteNonQuery();
                        }
                    }
                }
            }
            catch (Exception e)
            {
                reExp.Utils.Log.LogInfo("Error while shrinking db. " + e.Message, e, "RunSqlServer");
            }
        }