What's the best way to insert an entity only if there's a related row in the database with a particular column value. Something like this imaginary query...

INSERT INTO Foo (Id, col1) VALUES (4, 1)
INNER JOIN Bar ON Foo.Id = Bar.Id
WHERE Bar.Status = 1

That is not supported (passsing a IRelationPredicateBucket into an adapter.Save action). As I see it, the options are:

A. Check for the restriction before the insert. B. Do it at DB trigger level.

In t-sql I reckon it could be done using SELECT INTO.

Unfortunately not supported.