Add columns to SqlWebEventProvider
        Posted  
        
            by Julien N
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Julien N
        
        
        
        Published on 2009-11-05T14:25:17Z
        Indexed on 
            2010/06/02
            19:24 UTC
        
        
        Read the original article
        Hit count: 443
        
ASP.NET
|health-monitoring
In an asp.net application, we'd like to use the SqlWebEventProvider to log any Event that occurs during the application lifetime.
The problem is that we think that the table aspnet_WebEvent_Event doesn't provide enough columns and should log more information (we need to keep the Logged user).
I'm aware that this information could be stored in the "Details" column but it wouldn't then be really simple to filter the results and build reports.
So I'm searching for a simple solution to add a column. I wish I could derive SqlWebEventProvider but the methods used to build the stocked procedure parameters are private (PrepareParams() and FillParams()).
Any simple solution that doesn't imply to rewrite the entire Provider class ?
© Stack Overflow or respective owner