Esempi in C# (CSharp) per EmbeddedSqlScriptsHelper.SplitSqlStatements

Esempio n. 1

File: EmbeddedSqlScriptsHelperTests.cs Progetto: tmenier/CommonDotNetHelpers

        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);
        }

Esempio n. 2

File: EmbeddedSqlScriptsHelperTests.cs Progetto: tmenier/CommonDotNetHelpers

        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);
        }