Exemplo n.º 1
0
        public void TestUpperQueryFieldGetStringWithIndex()
        {
            // Prepare
            var functionalQueryField = new UpperQueryField("FieldName", Operation.Equal, "Value");

            // Act
            var text = functionalQueryField.GetString(1, new CustomDbSetting());

            // Assert
            Assert.AreEqual("UPPER([FieldName]) = @FieldName_1", text);
        }
Exemplo n.º 2
0
        public void TestUpperQueryFieldConstructor()
        {
            // Prepare
            var functionalQueryField = new UpperQueryField("FieldName", Operation.NotEqual, "Value");

            // Assert
            Assert.AreEqual("FieldName", functionalQueryField.Field.Name);
            Assert.AreEqual(Operation.NotEqual, functionalQueryField.Operation);
            Assert.AreEqual("Value", functionalQueryField.Parameter.Value);
            Assert.AreEqual("UPPER({0})", functionalQueryField.Format);
        }