If you use Adapter, you can override OnSaveEntity in a partial class of DataAccessAdapter. This partial class should be in the same DBSpecific project.
If you use SelfServicing you can override OnSaveComplete in the involved Entity's partial class.
I both cases you can know if it was an Insert or Update checking the .IsNew property (true=Insert, false=update).