Intercepting user activity

Paolo,

I'd suggest doing it in the SaveInterceptor, where you'd be able to create the "audit" entities and add them to the list of entities to be saved (i.e. Added/Modified/Deleted) before calling base.SaveChanges().

The only potential issue is with Added entities with Identity columns. A search in our forum will bring up a few threads discussing this. One of them is http://www.ideablade.com/forum/forum_posts.asp?TID=2717&KW=audit&PN=1&title=auditing-inserts-with-identity-columns.

Paolo,

In the interceptor, you will not be able to differentiate a "query" SP from a "save" SP.
I see 2 possibilities:
1) Handle the auditing of stored proc saved entities inside the stored proc;
2) Rather then handling auditing in the app, do it via a DB trigger.

Kind regards,
   Silvio.

Paolo,

I don't understand the question.
If you are using triggers, there shouldn't be a need to involve DevForce as it could be completely handled on the DB.

Hello,
I've found this http://msdn.microsoft.com/en-us/library/ms189252.aspx

it's possible to set this SessionContextInformation? is enougth to set this.Context = myValue in the EntityQueryInterceptor?

Thanks

You can take a look at a post I made in another topic on this forum.  We need to do something very similar to you - every time DevForce opens a SQL Connection (for querying or saving), we needed to 'mark' the connection with what user was active in the application.  Then triggers and procedures can see what the current user is to perform logging, security, etc.  In our case, we 'mark' the connection by setting data in the context_info property just like you seem to be thinking.  We have a stored procedure that takes in a few parameters (an int and a GUID) and takes care of converting them to the format needed for context_info.  We've found that setting context_info seems a lot faster than having to deal with temp tables....especially since connections will be opened/closed all the time.

Hello stephenmcd1,
as I wrote you on the other thread can you please provide me the implementation of ProviderRow?
I've managed to load my factory from web.config but I got the debugger continue breaking on

Factory

    public override DbConnection CreateConnection()
        {
            return new CustomDbConnection();//here
        }

which is called by CustomDbConnection:

 protected override string DefaultWrappedProviderName
        {
            get { return Invariants.Test; }
        }

Why this happen? It's an huge effort for you to produce me a simple mockup project? Thanks