#region script helper

private bool ExecuteScriptFile(string pathToScriptFile, out string errorMsg)

{

    StreamReader reader = null;

    DbConnection connection = null;

    string strSql;

    string applicationPath = Request.ApplicationPath;

    using (reader = new StreamReader(pathToScriptFile))

    {

    using (connection = new MySqlConnection(GetConnectionString()))

    {

        DbCommand dbCmd = connection.CreateCommand();

        dbCmd.Connection = connection;

        dbCmd.CommandType = CommandType.Text;

        dbCmd.CommandTimeout = ;

        // 考虑到安装脚本可能比较大，将命令超时时间设为6分钟

        connection.Open();

        while (!reader.EndOfStream)

        {

        try

        {

            strSql = NextSqlFromStream(reader);

            if (!string.IsNullOrEmpty(strSql))

            {

            dbCmd.CommandText = strSql.Replace("$VirsualPath$", applicationPath);

            dbCmd.ExecuteNonQuery();

            }

        }

        catch (Exception ex)

        {

            throw new Exception(ex.Message);

        }

        }

        connection.Close();

    }

    reader.Close();

    }

    errorMsg = null;

    return true;

}

private static string NextSqlFromStream(StreamReader reader)

{

    StringBuilder sb = new StringBuilder();

    string lineOfText = reader.ReadLine().Trim();

    while (!reader.EndOfStream && string.Compare(lineOfText, "GO", true, CultureInfo.InvariantCulture) != )

    {

    sb.Append(lineOfText + Environment.NewLine);

    lineOfText = reader.ReadLine();

    }

    // 如果最后一句不是GO,添加最后一句

    if (string.Compare(lineOfText, "GO", true, CultureInfo.InvariantCulture) != )

    sb.Append(lineOfText + Environment.NewLine);

    return sb.ToString();

}

#endregion

        /// <summary>

        /// 执行Sql文件

        /// </summary>

        /// <param name="varFileName">sql文件</param>

        /// <param name="Conn">连接字符串</param>

        /// <returns></returns>

        private bool ExecuteSqlFile(string varFileName, String Conn)

        {

            using (StreamReader reader = new StreamReader(varFileName, System.Text.Encoding.GetEncoding("utf-8")))

            {

                MySqlCommand command;

                MySqlConnection Connection = new MySqlConnection(Conn);

                Connection.Open();

                try

                {

                    string line = "";

                    string l;

                    while (true)

                    {

                        // 如果line被使用，则设为空

                        if (line.EndsWith(";"))

                            line = "";

                        l = reader.ReadLine();

                        // 如果到了最后一行，则退出循环

                        if (l == null) break;

                        // 去除空格

                        l = l.TrimEnd();

                        // 如果是空行，则跳出循环

                        if (l == "") continue;

                        // 如果是注释，则跳出循环

                        if (l.StartsWith("--")) continue;

                        // 行数加1

                        line += l;

                        // 如果不是完整的一条语句，则继续读取

                        if (!line.EndsWith(";")) continue;

                        if (line.StartsWith("/*!"))

                        {

                            continue;

                        }

                        //执行当前行

                        command = new MySqlCommand(line, Connection);

                        command.ExecuteNonQuery();

                    }

                }

                finally

                {

                    Connection.Close();

                }

            }

            return true;

        }