cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

.Net SqlClient Data Provider

henk_stobbe
Mentor

Hello,

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.

KR Henk

1 REPLY 1

Radu
Dynatrace Pro
Dynatrace Pro

Hi Henk,

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.

Best regards,

Radu