C# (CSharp) AdminQuery.FetchNextInto Examples

Example #1

        public void FetchIntoOneVar()
        {
            AdminQuery.FetchNextInto("c2", SqlExpression.VariableReference("var1"));

            var var1 = (Variable)AdminQuery.Access().GetObject(DbObjectType.Variable, new ObjectName("var1"));

            Assert.IsNotNull(var1);
            Assert.IsNotNull(var1.Evaluate(AdminQuery));
            Assert.IsFalse(Field.IsNullField(var1.Evaluate(AdminQuery)));

            var value = ((SqlNumber)var1.Evaluate(AdminQuery).Value).ToInt32();

            Assert.AreEqual(0, value);
        }