Is there a possibility to invoke an event or process when a new record is saves in the database or a record gets updated? Something db triggers?
We are looking at a rebuild of a existing application and when a record is saved it has to be processed immediately to validate it's values and when some om the values are off the scope we have to send a notification.
When those validations fail, do you intend to notify the user and stop the record from being saved? If so, you could create a wrapper action around the "Create" or "Update" entity actions. This wrapper action would perform the necessary validations and throw exceptions when they fail.
Of course, you would then have to make sure you use the wrapper action instead of the default entity actions.