Hi I created a constraint on the table for 4 different columns. This table has primary key besides unique constraint. LLBLGEN provides a way to fetch the entity based on the primary key. Does LLBLGEN also provides a way to fetch the entity based on the unique cosntraints. I tried using the following code but the isFlightExist returned is always false though we have the record in the database

predicateExpression = flightEntity.ConstructFilterForUCFlightNumberOriginDestinationSkedDepartGMTRef(); isFlightExist = _adapter.FetchEntityUsingUniqueConstraint(tmpFlight, predicateExpression);

Thanks.

Yes, the code snippet is the way to use it, however, you should set the fields forming the unique constraint to the proper values first. So: - set values in flightEntity for fields which are in the unique constraint - then use the code snippet above.

The flightEntity has values for the fields in the unique constraint. I did see the values in the predicateexpression returned from the ConstructFilterForUCFlightNumberOriginDestinationSkedDepartGMTRef() and it has the expected values.

Before creating unique constraint on the table, I tried creating predicate expression and used FetchEntityUsingUniqueConstraint() method and it did return true. Iam having problem after creating the unique constraints on the table.

Your help would be really appreciated.

Ali wrote:

The flightEntity has values for the fields in the unique constraint. I did see the values in the predicateexpression returned from the ConstructFilterForUCFlightNumberOriginDestinationSkedDepartGMTRef() and it has the expected values.

Before creating unique constraint on the table, I tried creating predicate expression and used FetchEntityUsingUniqueConstraint() method and it did return true. Iam having problem after creating the unique constraints on the table.

Your help would be really appreciated.

(btw, I did move your thread to the general forum and answered your question earlier on in that thread. But lets stick to this thread

The method ConstructFilterForUCFlightNumberOriginDestinationSkedDepartGMTRef should produce the same predicate expression as you otherwise would create by hand. That's the weird part. Could you check if that's the case? Be sure to use the predicate expression returned by ConstructFilterForUCFlightNumberOriginDestinationSkedDepartGMTRef !!

Sorry for creating different threads. Fixed the problem by passing valid object

Ali wrote:

Sorry for creating different threads. Fixed the problem by passing valid object

OK! No problem about hte threads, it wasn't very clear