logging driver for ADO.Net?

  • Thread starter Thread starter Michael Burstin
  • Start date Start date
M

Michael Burstin

I was wondering if anyone knew of a logging driver for ADO.Net. In
Java/JDBC, there are a few projects that are essentially driver "shims"
that get configured as a JDBC Driver which a program will use, that in
turn log the calls that are made, then pass these calls on to the real
driver down to the database. For example, there is P6spy/P6log
(http://www.p6spy.com/) for JDBC.
 
Hi Michael,

The ADO.NET provider doesn't support logging itself. Nor did I found any
logging driver for ADO.NET by googling through the web. I think maybe some
community member may have some idea of this driver from a 3rd party vendor.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Michael,

For logging in dotNet is more than one method, if you are using AdoNet with
strongly typed datasets, than you can that in my idea to the class using a
partial class.

Just my idea,

Cor
 
Right, but I was looking for something for an app that I don't
necessarily have source-code access to...
 
Hi Michael,

Please correct me if I'm wrong. If we don't have access to the source code
of the app, we cannot replace the data tier that app use with our logging
data tier. In this case, I think we can use some trace tools like SQL
Profiler to log the database events. Does this meet your requirements?

Kevin Yu
Microsoft Online Community Support
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Hi Michael,

I'd like to know if this issue has been resolved yet. Is there anything
that I can help. I'm still monitoring on it. If you have any questions,
please feel free to post them in the community.

Kevin Yu
Microsoft Online Community Support
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
I'm thinking more in the JDBC mindset where the JDBC (and probably
ADO.Net 2.0 base classes/factories -- I have not used those yet) driver
is loaded dynamically. Yes, I suppose this is not at all possible in
ADO.NET 1.1 where even use of an IDbConnection needs to be New-ed via a
provider-specific class.
 
Back
Top