Archon.Data.Database.Rebuild C# (CSharp) Method

        public void Rebuild(string connectionString)
        {
            var builder = new SqlConnectionStringBuilder(connectionString);

            string database = builder.InitialCatalog;
            builder.InitialCatalog = "";

            using (var conn = new SqlConnection(builder.ToString()))
            {
                conn.Execute(String.Format(@"
                    if db_id('{0}') is not null
                    begin
                        alter database {0} set single_user with rollback immediate;
                        drop database {0};
                    end", database
                ));
            }

            Build(connectionString);
        }