Retreive entities with null value in a field : Use the OQL to solve this one....

Thu, 13 Sep 2007 09:45:30 -700

Author: Linguinut
Subject: 427
Posted: 13-Sep-2007 at 9:45am

Use the OQL to solve this one. Remove the line "oCol.Add(DBNull.Value)" and add another AddClause with an OR operative. Utilize the EntityQueryOp.IsNull parameter.

Retreive entities with null value in a field : How to add a clause that specify...

Thu, 13 Sep 2007 05:49:20 -700

Author: f3rland
Subject: 427
Posted: 13-Sep-2007 at 5:49am

How to add a clause that specify DBNull?

Dim oResult As EntityList(Of SomeProject.Something)
Dim oQuery As New EntityQuery(GetType(SomeProject.Something))
Dim oCol As New Collection
'oCol.Add(DBNull.Value)   <----- here is the problem!
oCol.Add("**")
oCol.Add("")
oQuery.AddClause(SomeProject.Something.StringFieldThatCanBeNullEntityColumn, EQO.In, oCol) ' <----  Throw exception here

Thanks!

Edited by f3rland - 13-Sep-2007 at 6:57am

DevForce Community Forum : Retreive entities with null value in a field

Retreive entities with null value in a field : Use the OQL to solve this one....

Retreive entities with null value in a field : How to add a clause that specify...