C#中执行.sql的文件

1 使用前记得引入命名空间：using System.Text;

private static void ExecuteSQLFile(String sqlFileName)

        {

            SqlConnection connecction = null;

            try

            {

                connecction = new SqlConnection(@"uid=XXXX; pwd=XXXX; server=XXXX; database=XXXX; connection timeout=30");

                SqlCommand command = connecction.CreateCommand();

                connecction.Open();

 

                FileStream stream = new FileStream(sqlFileName, FileMode.Open);

                StreamReader reader = new StreamReader(stream);                             

 

                StringBuilder builder = new StringBuilder();

                String strLine = "";

                while ((strLine = reader.ReadLine()) != null)

                {

                    if (strLine.Trim().ToUpper() != @"GO")

                    {

                        builder.AppendLine(strLine);

                    }

                    else

                    {

                        command.CommandText = builder.ToString();

                        command.ExecuteNonQuery();

                        builder.Remove(0, builder.Length);

                    }

                }

 

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.Message);

            }

            finally

            {

                if (connecction != null && connecction.State != ConnectionState.Closed)

                {

                    connecction.Close();

                }

            }

        }