Esempi in C# (CSharp) per Deveel.Data.Sql.Expressions SqlExpression.Like

Like() public static method

public static Like ( SqlExpression left, SqlExpression right ) : SqlBinaryExpression
left	SqlExpression
right	SqlExpression
return	SqlBinaryExpression

Esempio n. 1

        public static void VisitStringMatch()
        {
            var exp = SqlExpression.Like(SqlExpression.Constant(SqlObject.String(new SqlString("antonello"))),
                                         SqlExpression.Constant(SqlObject.String(new SqlString("an%"))), null);

            Visit(exp);
        }

Esempio n. 2

        public void StringLikesPattern(string input, string patern, bool expected)
        {
            var exp1    = SqlExpression.Constant(Field.String(patern));
            var exp2    = SqlExpression.Constant(Field.String(input));
            var likeExp = SqlExpression.Like(exp1, exp2);

            SqlExpression resultExp = null;

            Assert.DoesNotThrow(() => resultExp = likeExp.Evaluate());
            Assert.IsNotNull(resultExp);
            Assert.IsInstanceOf <SqlConstantExpression>(resultExp);

            var constExp = (SqlConstantExpression)resultExp;

            Assert.IsNotNull(constExp.Value.Value);
            Assert.IsInstanceOf <BooleanType>(constExp.Value.Type);
            Assert.IsInstanceOf <SqlBoolean>(constExp.Value.Value);

            var actual         = ((SqlBoolean)constExp.Value.Value);
            var expectedResult = new SqlBoolean(expected);

            Assert.AreEqual(expectedResult, actual);
        }