Have a look at nhibernate envers. It does all the logging
automatically for you.

On Aug 19, 6:55 am, scorefande <[email protected]> wrote:
> Hi, my goal is to log all changes (INSERT, UPDATE, DELETE) made to the
> database. At the moment I use the "state" properties of the event args
> from the event listener API of NHibernate.
>
> Unfortunately this doesn't work well if the changed property itself is
> another entity or if a user type is used. In these cases I would like
> to log the entity's Id/the value of the db columns etc.
>
> But I did not found any data in the event args (IEntityPersister,
> ISession, etc.) that contain the original values of the db columns. Is
> this actually possible?
>
> Here's a sample where an INSERT operation in handled.
> result.DatabaseValues contains the changed data.
> private DatabaseOperation CreateInsertOperation(PostInsertEvent
> @event, LoggedClassConfiguration entityLoggingConfiguration)
>   {
>      string tableName = @event.Persister.QuerySpaces.First();
>      DatabaseOperation result = ...
>
>      object[] newState = @event.State;
>      for (int i = 0; i < newState.Length; i++)
>      {
>         object newValue = newState[i];
>
>         PropertyColumnMapping map =
> entityLoggingConfiguration.GetMapping(@event.Persister.PropertyNames.Elemen 
> tAt(i));
>         if (map == null)
>         {
>            continue;
>         }
>
>         result.DatabaseValues.Add(new DatabaseValue
>         {
>            NewValue = newValue,
>            FieldName = map.DatabaseColumnName
>         });
>      }
>
>      return result;
>   }

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to