Acme.PROJECTNAME.Install.SqlServers.ReadSQLFileSectionsFromFile C# (CSharp) Метод

		private static string[] ReadSQLFileSectionsFromFile(string fileName)
		{
			ArrayList retval = new ArrayList();
			StringBuilder sb = new StringBuilder();
			Assembly asm = Assembly.GetExecutingAssembly();

			StreamReader manifestStream = File.OpenText(fileName);
			try
			{
				while (!manifestStream.EndOfStream)
				{
					string lineText = manifestStream.ReadLine();
					if (lineText.ToUpper().Trim() == "GO")
					{
						retval.Add(sb.ToString());
						sb = new StringBuilder();
					}
					else
					{
						sb.AppendLine(lineText);
					}
				}
			}
			catch { }
			finally
			{
				manifestStream.Close();
			}
			//Last string
			if (sb.ToString() != "")
				retval.Add(sb.ToString());

			return (string[])retval.ToArray(typeof(string));
		}