Deveel.Data.InsertSelectTests.WithColumns C# (CSharp) Method

        public void WithColumns()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var query = (SqlQueryExpression)SqlExpression.Parse("SELECT 'Antonello', 'Provenzano', NULL, NULL");
            var columns = new[] { "first_name", "last_name", "birth_date", "active" };

            var count = AdminQuery.InsertSelect(tableName, columns, query);

            Assert.AreEqual(1, count);

            var table = AdminQuery.Access().GetTable(tableName);

            Assert.AreEqual(1, table.RowCount);
        }