Blog.Tools.ApplicationSetup.Program.DropBlogDb C# (CSharp) Method

		private static void DropBlogDb()
		{
			var connectionstring = ConfigurationManager.AppSettings.Get("MasterDb");
			var dbName = ConfigurationManager.AppSettings.Get("BlogDbName");

			using (var con = new SqlConnection(connectionstring))
			{
				con.Open();
				var sqlCommandText = @"
					ALTER DATABASE " + dbName + @" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
					DROP DATABASE [" + dbName + "]";
				var sqlCommand = new SqlCommand(sqlCommandText, con);
				sqlCommand.ExecuteNonQuery();
			}
		}