Tech Off Post

Single Post Permalink

View Thread: Run SqlScript from ado
  • User profile image

    well you could still do that and just remove the go statements... with something like

    string sql = file.readtoend()

    Regex regex = new Regex("^GO",Regex.IgnoreCase | Regex.Multiline)
    string[] lines = regex.split(sql)

    and then foreach the lines and then execute each line. if it has a value