Error : NHibernate.Hql.Ast.HqlBooleanExpression

[Christian I.]

Hello,

I have this error : 

{"Unable to cast object of type 'NHibernate.Hql.Ast.HqlBitwiseAnd' to type 'NHibernate.Hql.Ast.HqlBooleanExpression'."}

I create a predicate in C# with Expression Method, like this :

var listExpression = new List<Expression>();

var parameter = Expression.Parameter(typeof(T));

listExpression.Add(

Expression.Call(

((MemberExpression)memberExpression), "Contains", null,

Expression.Constant((string)MyValue))

);

Expression body = Expression.Constant(true);

foreach (var expression in listExpression)

body = Expression.And(body, expression);

The predicate looks like : see attachment.

I use this predicate like this :

session.QueryOver<Customer>().Where(prediate).List()

That's work when I have one condition in my predicate but I get the error when I have more than one

Any idea ?

[Ricardo Peres]

Use Expression.AndAlso, not Expression.And.

RP

[Christian I.]

Thanks Ricardo that's work.

I have a bonus question. My predicate on the image join in the first post is : Param_0.LastName.Contains("..")

Is there a way to have : Param_0.LastName.ToUpper().Contains(".."). I'd like avoid difference between capital and not capital.

Thanks,

On Tuesday, September 4, 2012 10:57:31 PM UTC+2, Ricardo Peres wrote:

Use Expression.AndAlso, not Expression.And.

[Ricardo Peres]

You will have to wrap your call to Contains() inside a MethodCallExpression that calls ToUpper() first. Similar to what you already have.

RP