Exemple #1
0
        public void TestLeftQueryFieldGetStringWithIndex()
        {
            // Prepare
            var functionalQueryField = new LeftQueryField("FieldName", Operation.Equal, "Value");

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

            // Assert
            Assert.AreEqual("LEFT([FieldName], 5) = @FieldName_1", text);
        }
Exemple #2
0
        public void TestLeftQueryFieldConstructor()
        {
            // Prepare
            var functionalQueryField = new LeftQueryField("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("LEFT({0}, 5)", functionalQueryField.Format);
        }