LLBLGEN 3.1 Rel Date 16/03/2011 .NET frame work 2.0 Windows Application DB: Oracle 9i / 10g MSORACLE

In the following FieldCompareValuePredicate, generalmeetdate I am passing null depending on the business logic. Now when it is null it throws exception. Is there a way to check this ?

var filterdescription = new FieldCompareValuePredicate(GeneralmeetFields.Description, null, ComparisonOperator.Equal, description); var Generalmeetdate = new FieldCompareValuePredicate(GeneralmeetFields.Generalmeetdate, null, ComparisonOperator.Equal, date);

IPredicate Generalmeetdate = date==null ? new FieldCompareNullPredicate(GeneralmeetFields.Generalmeetdate, null) : new FieldCompareValuePredicate(GeneralmeetFields.Generalmeetdate, null, ComparisonOperator.Equal, date);

better is to do: IPredicate Generalmeetdate = GeneralmeetFields.Generalmeetdate==(date ?? DBNull.Value);

this will auto-select the predicate to use based on the date value.

Otis wrote:

IPredicate Generalmeetdate = GeneralmeetFields.Generalmeetdate==(date ?? DBNull.Value);

Operator ?? cannot be applied to operands of type 'string' and 'system.DBnull'

I am passing date as string

shekar wrote:

Otis wrote:

IPredicate Generalmeetdate = GeneralmeetFields.Generalmeetdate==(date ?? DBNull.Value);

Operator ?? cannot be applied to operands of type 'string' and 'system.DBnull'

I am passing date as string

Well, you do know a little bit about C# or not? object toCompareWith = date; if(toCompareWith == null) { toCompareWith = DBNull.Value; } IPredicate Generalmeetdate = GeneralmeetFields.Generalmeetdate==toCompareWith;