Hi All,
Background:
I am looking at writting a wrapper application that would capture querries connecting to SQL Server or any other database via ADO.NET for analysis prior to their execution and am wondering if there is a way to modify/replace the base class, put in place my wrapper to do its work and then call the original class library for the actual datbase connection. If this is possible, it will allow me to easily integrate my wrapper with any other compiled application using ADO.NET to access a database without updating references in the application source code and recompiling it; I really need to avoid the extreme amount of regression testing that this would require me to do.
Question:
Is it possible to make modifications to the .NET Framework System.Data.SqlClient class or other classes and have them work within the framework
Guidance is appreciated!
System.Data.SqlClient
xavito
fripper
hi nobugz,
Thanks for the suggested reading and sorry for not getting back on the thread sooner. I trust you had a wonderfull New Year.
I have read throught the URL you suggested and while it has some usefull information, it is not exactly what I am looking for as it is used as a debugging tool that is ment to trace the vaious levels of the stack when executing commands and can have a large amount of output depending on the command traced. What I am actually looking to do is to capture the SQL statement prior to it reaching the natvie provider via system.data.sqlclient such that I can parse it, make any modifications necessary, and then execute the query (modified or not) using the native driver (ADO.NET).
Thus, I would like to be able to replace and rename the files within the .NET framework that are responsible for the functionality of the System.Data.SQLClient class library such that I can "wrap" around it and then call it to actually perform the data access required by the application.
I hope this makes things a little clearer. Thanks in advance for you input.
---Jay