Diego, I have done this exact thing, although my intentions were different. I wanted to create a logging table that has an auto-increment field and be able to return the value for that field. Since each logging call could go be written to multiple ADONETAppenders and therefore have several sets of result data, the return values are put into an array as suggested by Nicko. I have been waiting to post my new class on this list because it has only been minimally tested, but if there is already need for it, here it is. I hope I can attach files to this email. If they get filtered off this message, I can send them directly to you. Just add these files into the existing project according to their namespaces. Of course, feel free to change them as needed.
Aaron Hart -----Original Message----- From: Diego Barros [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 10:32 PM To: [email protected] Subject: ADONETAppender and stored procedures Hi all, I was wondering if the ADONETAppender could make use of output stored procedure parameters? I wish the logging to call a stored procedure and then have it return some values (via output parameters), then use the returned values elsewhere. For example, I wish to log to the event log the returned values from the stored procedure. Would I be better off implementing my own appender (by taking the ADONetAppender) and making it do what I want, like get the returned values from the stored procedure? Any help or pointers as to how I can implement this would be greatly appreciated. Cheers, Diego
IParameterLog.cs
Description: IParameterLog.cs
ParameterLogManager.cs
Description: ParameterLogManager.cs
ADONetReturnValueAppender.cs
Description: ADONetReturnValueAppender.cs
ParameterLogImpl.cs
Description: ParameterLogImpl.cs
