logging driver for ADO.Net?

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.

v-kevy
Wed Oct 04 21:22:23 CDT 2006

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.)

Cor
Wed Oct 04 22:40:17 CDT 2006

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

"Michael Burstin" <mburstin@newsgroups.nospam> schreef in bericht
news:OGpbC$95GHA.4304@TK2MSFTNGP03.phx.gbl...
>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.

Michael
Thu Oct 05 10:31:23 CDT 2006

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

Cor Ligthert [MVP] wrote:
> 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
>
> "Michael Burstin" <mburstin@newsgroups.nospam> schreef in bericht
> news:OGpbC$95GHA.4304@TK2MSFTNGP03.phx.gbl...
>> 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.
>
>

v-kevy
Mon Oct 09 04:42:02 CDT 2006

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.)

v-kevy
Tue Oct 10 23:08:33 CDT 2006

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.)

Michael
Thu Oct 12 10:51:36 CDT 2006

Sure, go ahead and close.

Kevin Yu [MSFT] wrote:
> 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.)
>

Michael
Thu Oct 12 11:00:18 CDT 2006

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.

Kevin Yu [MSFT] wrote:
> 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.)
>