public void SplitSqlStatements_GOWithSemicolonBefore_IncorrectSeparator() { string script = @"SELECT * FROM information_schema.tables ; GO SELECT * FROM INFORMATION_SCHEMA.TABLES"; var commands = EmbeddedSqlScriptsHelper.SplitSqlStatements(script); commands.Count().Should().Be(1); }
public void SplitSqlStatements_GOonSeparateLine_CorrectSeparator() { string script = @"SELECT * FROM information_schema.tables GO SELECT * FROM INFORMATION_SCHEMA.TABLES"; var commands = EmbeddedSqlScriptsHelper.SplitSqlStatements(script); commands.Count().Should().Be(2); }