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: 390
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