# Dot net Depency Problem

**URL:** <https://discuss.elastic.co/t/dot-net-depency-problem/360118>\
**Category:** APM\
**Tags:** dotnet\
**Created:** [May 24, 2024, 4:46am UTC](https://discuss.elastic.co/t/dot-net-depency-problem/360118 "2024-05-24T04:46:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![eagles40cnuh](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@eagles40cnuh](https://discuss.elastic.co/u/eagles40cnuh)\
**Post date:** [May 24, 2024, 4:46am UTC](https://discuss.elastic.co/t/dot-net-depency-problem/360118/1 "2024-05-24T04:46:50Z")

</div>

**Kibana version** : 8.13.2  
**Elasticsearch version** : 8.13.2  
**APM Server version** : 8.13.2  
**APM Agent language and version** : dotnet

1. APM was installed on the site being serviced by IIS 10 and Profiler Auto instrumentation was applied.

2. Config Setting IIS

name="COMPlus\_LoaderOptimization" value="1"

name="COR\_PROFILER\_PATH"value="C:\TEMP\APM\elastic\_apm\_profiler.dll

name="ELASTIC\_APM\_PROFILER\_INTEGRATIONS" value="C:\TEMP\APM\integrations.yml"

name="ELASTIC\_APM\_PROFILER\_HOME" value="C:\TEMP\APM"  
name="COR\_PROFILER" value="{FA65FE15-F085-4681-9B20-95E04F6C03CC}"  
name="COR\_ENABLE\_PROFILING" value="1"  
name="ELASTIC\_APM\_SERVER\_URL" value="[https://xxx.xxx.xxx.xxx:8200](https://xxx.xxx.xxx.xxx:8200)"

1. The http request is being viewed normally  

2. BUT SQL command connected to the web service is not being viewed at all.  

3. AND Trace Log Config  
[2024-05-24T13:26:42.269259800+09:00] [TRACE] -\> System.Data.CommandBehavior = System.Data.CommandBehavior  
[2024-05-24T13:26:42.269264900+09:00] [INFO] enqueue for ReJIT module\_id=140733202783800, method\_def=100669857, app\_domain\_id=2531742682912, domain\_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteReader, signature=[32, 1, 18, 135, 32, 17, 130, 92]  
[2024-05-24T13:26:42.269273100+09:00] [DEBUG] The caller for method\_def ExecuteReader expected 2 arguments while integration has 1  
[2024-05-24T13:26:42.269293200+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteDbDataReader  
[2024-05-24T13:26:42.269299500+09:00] [TRACE] -\> System.Data.CommandBehavior = System.Data.CommandBehavior  
[2024-05-24T13:26:42.269304800+09:00] [INFO] enqueue for ReJIT module\_id=140733202783800, method\_def=100669855, app\_domain\_id=2531742682912, domain\_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteDbDataReader, signature=[32, 1, 18, 139, 196, 17, 130, 92]  
[2024-05-24T13:26:42.269324800+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteScalarAsync  
[2024-05-24T13:26:42.269330500+09:00] [TRACE] -\> System.Threading.CancellationToken = System.Threading.CancellationToken  
[2024-05-24T13:26:42.269335500+09:00] [INFO] enqueue for ReJIT module\_id=140733202783800, method\_def=100669875, app\_domain\_id=2531742682912, domain\_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteScalarAsync, signature=[32, 1, 21, 18, 134, 65, 1, 28, 17, 134, 73]  
[2024-05-24T13:26:42.269355300+09:00] [TRACE] comparing signature for method System.Data.SqlClient.SqlCommand.ExecuteScalar  
[2024-05-24T13:26:42.269360600+09:00] [INFO] enqueue for ReJIT module\_id=140733202783800, method\_def=100669826, app\_domain\_id=2531742682912, domain\_neutral=false, assembly=System.Data, type=System.Data.SqlClient.SqlCommand, method=ExecuteScalar, signature=[32, 0, 28]

Why doesn't SQL DEPENDENCY appear?