Hi there,

I'm looking for a predicate expression that updates a row only if the row is referenced by x number of rows.

So something like this...

UPDATE A a SET a.Locked = true WHERE @quantity = (SELECT count(*) FROM B WHERE b.fkey = a.pkey) AND a.pkey = 1;

Any ideas?

Cheers, Ian.

You can use ScalarQueryExpression and expressions in your PredicateExpression. See this example (it uses SUM, but you just chance it for COUNT): http://www.llblgening.com/archive/2009/09/llblgen-pro-expressions-and-scalar-queries/