/// <summary> /// Returns the seperate executable SQL commands within the SQL script. /// </summary> /// <param name="scriptContents"></param> /// <returns></returns> public virtual IEnumerable <string> SplitScriptIntoCommands(string scriptContents) { using (var reader = new SqlCommandReader(scriptContents)) { var commands = new List <string>(); reader.ReadAllCommands(c => commands.Add(c)); return(commands); } }
/// <summary> /// Returns the seperate executable SQL commands within the SQL script. /// </summary> /// <param name="scriptContents"></param> /// <returns></returns> public virtual IEnumerable<string> SplitScriptIntoCommands(string scriptContents) { using (var reader = new SqlCommandReader(scriptContents)) { var commands = new List<string>(); reader.ReadAllCommands(c => commands.Add(c)); return commands; } }