I have a user that uses: ".Net SqlClient Data Provider", and he has long running queries. I assume Dynatrace does not show these queries as no ODBC layer is used?
The .NET Framework Data Provider for SQL Server (SqlClient) uses its own protocol to communicate with SQL Server. It is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.
Solved! Go to Solution.
From what I can see in the Microsoft documentation, the .NET Framework Data Provider for SQL Server implemented as System.Data.SqlClient (or the newer Microsoft.Data.SqlCient) still uses the ADO.NET driver for communicating with the SQL Server database.
Technically, as long as we can inject in the .NET processes that implements this Data.SqlClient framework we should still be able to instrument the ADO.NET driver and get the connection string and query.