NHibernate: audit log using Interceptor or Triggers?

Triggers look like a simple audit logging solution. Why should I use interceptors?

  • Database portability is one of the triggers for launching ...

what others?

+3
source share
5 answers

Another minor issue is that triggers do any DML. nHibernate uses counted lines to determine success in many of its operations. If you do any insertions / updates / etc. inside your triggers, then you need to enable NOCOUNT inside the triggers to prevent false lines from appearing.

, , , . EventListeners - , .

, icky T-SQL...

0

Con -, , , . , , (, - 10%). , , . sql , , , , . , , , . , , evreything , , , . , , SSIS ( DTS) , , . , , , GUI .

+2

, :

  • . .

  • . .. , , .

. , , , HLGEM . senario.

+1

HLGEM. , , : :

+1

, . -, .

, - . . , , , , (.. ).

0

Source: https://habr.com/ru/post/1703766/


All Articles