Hi there

I have 3 tables Student, Book, StudentBook Now I want to pick up all those records which doesn't exists int the StudentBookTable(RelatedTable) . Can anyone tell me how to do that?.

i.e select * from students where studentid not in (select studentid from studentbook)

How to do this in self service with EntityCollection

For the "NOT IN" predicate you should use FieldComapreSetPredicate. And make sure to use the overload that accepts the negate parameter (set it to true, to get the NOT).

Thanks buddy

Hi there

How can we change database connection while taking the built Gen pro code to the deployement server from development site in self service.

I also want to know if I want to compare the expression generated by two fields what predicate will be used

e.g:-

select * from Student where Student.HeightFeet * 12 + Student.Heightinches >= 172

We'll address your connection string question in the other thread that you started - please try to keep threads to one question as it make it much easier for us to keep track of them!

Have a look at the documentation on using field expressions in predicates

http://www.llblgen.com/documentation/3.1/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_expressionsaggregates.htm#expressionsinpredicates

Matt

How to do this with the entity collection

That's a predicateExpression and predicateExresions can be used when fetching EntityCollections.