Deveel.Data.Sql.Statements.InsertStringFormatTests.MultiSet C# (CSharp) Метод

        public static void MultiSet()
        {
            var statement = new InsertStatement(ObjectName.Parse("t1"), new[] {
                "first_name", "last_name", "age"
            }, new[] {
                new SqlExpression[] {
                    SqlExpression.Constant("Antonello"),
                    SqlExpression.Constant("Provenzano"),
                    SqlExpression.Constant(34)
                },
                new SqlExpression[] {
                    SqlExpression.Constant("Sebastiano"),
                    SqlExpression.Constant("Provenzano"),
                    SqlExpression.Constant(33)
                },
            });

            var sql = statement.ToString();
            var expected = new StringBuilder();
            expected.AppendLine("INSERT INTO t1(first_name, last_name, age)");
            expected.AppendLine("  VALUES");
            expected.AppendLine("  ('Antonello', 'Provenzano', 34),");
            expected.Append("  ('Sebastiano', 'Provenzano', 33)");

            Assert.AreEqual(expected.ToString(), sql);
        }