Optimize For with predicate

[BEagle1984]

I know it's not super easy but I'd expect the predicate to be passed in the update statement instead of executing a query just to load the primary keys.
Plus I wouldn't rely on EF but use a raw sql, aiming at getting rid of the dependency to EF.

[ppx80]

Hi @BEagle1984, thanks for the suggestion.
I'm working on a method (named Where) that should be doing exactly what you described.
I use EF because it allows me to generate the query starting from the given entity. Starting with SqlConnection forces me to re-engineer everything ..... But I can think about it.