Is it is possible to do any kind of validation as part of saving entities, after the transaction has opened, but before the commit operation? This is required so that the validation logic that is in a sql server stored procedure can access the data that is being saved (but not committed yet) as part of the validation and disallow save if the validation fails. We cannot do this kind of logic in the client as the client may not have all the data retrieved into the Entity Manager. Essentially, what I am looking for is a kind of pre-commit event as part of the SaveChanges() method.
Thanks