예제 #1
0
        public bool ExecuteQueries()
        {
            ////Execute the queries
            foreach (DatabaseQuery q in Queries)
            {
                if (q.Message == Messages.DropDatabase || q.Message == Messages.CreateDatabase || q.Message == Messages.EnableDBCT || q.Message == Messages.DisableDBCT || q.Message == Messages.AlterDatabase)
                {
                    OnUpgrading(q);
                    string error       = "";
                    int    queryResult = DbInfo.ExecuteNonQuery(q.SqlStatement, true, out error);

                    if (queryResult > 0 || queryResult == -1)
                    {
                        q.Result = 1;
                    }
                    else
                    {
                        q.Result       = -1;
                        q.ErrorMessage = error;
                    }
                }
            }

            //// Execute all sql statements NOT related to create, drop or alter database etc...
            DbInfo.BeginTransaction(false);
            foreach (DatabaseQuery q in Queries)
            {
                if (q.Message != Messages.DropDatabase && q.Message != Messages.CreateDatabase && q.Message != Messages.EnableDBCT && q.Message != Messages.DisableDBCT && q.Message != Messages.AlterDatabase)
                {
                    OnUpgrading(q);
                    string error       = "";
                    int    queryResult = DbInfo.ExecuteNonQuery(q.SqlStatement, out error);

                    if (queryResult > 0 || queryResult == -1)
                    {
                        q.Result = 1;
                    }
                    else
                    {
                        q.Result       = -1;
                        q.ErrorMessage = error;
                    }
                }
            }

            //// Rollback transaction if execution of any sql statement failed on the database. Otherwise commit transaction
            if (Queries.HasErrors)
            {
                DbInfo.RollBackTransaction();
                return(false);
            }
            else
            {
                DbInfo.CommitTransaction();
                return(true);
            }
        }