DevForce Community Forum : Entity Server Exception creating PredicateDescription with InList operator on nullable db properties

Entity Server Exception creating PredicateDescription with InList operator on nullable db properties : Hi pk55;This has just been fixed....

Mon, 11 Jul 2011 16:54:10 -700

Author: DenisK
Subject: 2806
Posted: 11-Jul-2011 at 4:54pm

Hi pk55;

This has just been fixed. The patch I sent you doesn't contain this fix. If you want, you can hold off on downloading that patch and I can send you a new one that includes this.

Entity Server Exception creating PredicateDescription with InList operator on nullable db properties : Thanks pk55. I've submitted...

Fri, 01 Jul 2011 18:26:25 -700

Author: DenisK
Subject: 2806
Posted: 01-Jul-2011 at 6:26pm

Thanks pk55. I've submitted another bug report for this. Just so we're on the same page, I had to modify the code as follows for it to throw the same exception.

var list = new short?[] { 1, 2 };
var p = new PredicateDescription(typeof(Product), Product.EntityPropertyNames.UnitsInStock, FilterOperator.InList, list);

Entity Server Exception creating PredicateDescription with InList operator on nullable db properties : I get entity server exceptions...

Thu, 30 Jun 2011 18:50:12 -700

Author: pk55
Subject: 2806
Posted: 30-Jun-2011 at 6:50pm

I get entity server exceptions when I try to build a predicate description (either through PredicateBuilder.Make or just newing up a PredicateDescription) when the property to compare to is nullable in the db (with the exception of nullable stirngs; those always seem to work). I've tried explicitly casting values to the nullable type (like int?), typing it as an nullable IList, etc. and nothing seems to work.

I'm using the 6.1.2.0c build. This was from an nullable int property:

Exception Type: IdeaBlade.EntityModel.EntityServerException
Message: Invalid values for InList operation - not all values of type: System.Nullable`1[System.Int32]
RemoteExceptionName: System.ArgumentException
RemoteExceptionDetails: System.ArgumentException: Invalid values for InList operation - not all values of type: System.Nullable`1[System.Int32]
   at IdeaBlade.Linq.PredicateDescription.Validate()
   at IdeaBlade.Linq.PredicateDescription.Initialize(FilterOperator filterOp, Object value, Boolean ignoreCase)
   at IdeaBlade.Linq.PredicateDescription..ctor(Type instanceType, String propertyPath, FilterOperator filterOp, Object value, Boolean ignoreCase)

You can try it against NorthwindIB Product table. It has some nullable smallint types:

var p = new PredicateDescription(typeof(Product), "UnitsInStock", FilterOperator.InList, new[] {1,2});

This works fine against a non-nullable db column and as I said, works on nullable strings.