Capture SQL queries of certain entity types

[pp-mluthi]

Hello,

In a C# application, using nHibernate & fluent nHibernate, we're looking to capture certain INSERT, UPDATE, DELETE queries performed on a Sqlite database in order to replicate them.
We'd like to replicate only certain queries that affect certain entity types.

After several searches and tests, we haven't found a way to do this.

Ideally, we'd like to reproduce the delta mechanism proposed by SyncFramework (https://github.com/egarim/SyncFramework/tree/main).

We have developed a solution using an Interceptor as well as Listeners, but neither solution seems to work.
An Interceptor can be used to retrieve the generated SQL, but we lack context for its application.
Listeners (IPostInsertEventListener, IPostUpdateEventListener, IPostDeleteEventListener) have many more parameters, but we can't find a way to retrieve the raw SQL query.

Thanks in advance for your help!