private static string[] ReadSQLFileSectionsFromResource(string resourceFileName)
{
ArrayList retval = new ArrayList();
StringBuilder sb = new StringBuilder();
Assembly asm = Assembly.GetExecutingAssembly();
System.IO.Stream manifestStream = asm.GetManifestResourceStream(resourceFileName);
try
{
using (System.IO.StreamReader sr = new System.IO.StreamReader(manifestStream))
{
while (!sr.EndOfStream)
{
string lineText = sr.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));
}