ManagerTest.Database.ExecuteSql.ExecuteTransactionlessNonQuery C# (CSharp) Method

		public void ExecuteTransactionlessNonQuery(string sql, int timeout = 30)
		{
			HandleWithRetry(sql, s =>
			{
				using (var connection = _openConnection())
				{
					using (var command = connection.CreateCommand())
					{
						command.CommandType = CommandType.Text;
						command.CommandTimeout = timeout;
						command.CommandText = sql;
						command.ExecuteNonQuery();
					}
				}
			}, 0);
		}

        public void CreateDatabase(string scriptFilePath, string databaseName)
        {
            var tasks = new DatabaseTasks(_executeMaster);

            if (tasks.Exists(databaseName))
            {
                tasks.SetOnline(databaseName);                 // if dropping a database that is offline, the file on disk will remain!
                _executeMaster.ExecuteTransactionlessNonQuery(
                    string.Format("ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;", databaseName));
                tasks.Drop(databaseName);
            }


            try
            {
                var script = File.ReadAllText(scriptFilePath + "CreateDB.sql");
                script = ReplaceScriptTags(script, databaseName);
                _executeMaster.ExecuteTransactionlessNonQuery(script, 10800);
            }
            catch (Exception exception)
            {
                string msg = exception.StackTrace;
            }
        }