HnD | select * from Table where ID in (...), SQL 2005, Page 1

select * from Table where ID in (...), SQL 2005

Posts

Chaos
User

Posts: 33
Joined: 13-Jul-2006

# Posted on: 02-Nov-2006 18:10:08

Sorry, if I am missing something fundamental, but how can I get an EntityCollection, say EntityCollection<SomeEntity>with SomeEntityFactory, and filtering the fetch by SomeEntity.ID?

I mean how do I "select * from Table where ID in (a_big_list_of_ids)" in llblgen?

I guess, I can fetch SomeEntity for each ID in the list, but that's like so many requests for the server(while it can be just one), so is there some smart predicate-expression or something ... or is there something i just can't remember right now ?

Thanx in advance, Chaos.

P.S. Salute, Firewind - Allegiance

bclubb
User

Posts: 934
Joined: 12-Feb-2004

# Posted on: 03-Nov-2006 03:45:14

I'm not sure what scenario you are running but the section Generated Code - The predicate system will define the FieldCompareSetPredicate which will do what you are describing.

Chaos
User

Posts: 33
Joined: 13-Jul-2006

# Posted on: 03-Nov-2006 09:21:00

Err, yeah, thanks,

Firewind.

Chaos.