检查以下解决方法，以在Application Insights for Asp.Net Framework Application中跟踪SQL查询和依赖关系。

• 我已经按照您提供的相同document自动添加应用程序洞察。
• 在ApplicationInsights.config文件中添加Application Insights连接字符串。
• 正如Application Insights中的MSDoc依赖项跟踪中所提到的，我在ApplicationInsights.config中的<TelemetryModules>下添加了以下设置。

<EnableSqlCommandTextInstrumentation>true</EnableSqlCommandTextInstrumentation>

• 确保您的Web.config已添加以下设置。

<add name="TelemetryCorrelationHttpModule" type="Microsoft.AspNet.TelemetryCorrelation.TelemetryCorrelationHttpModule, Microsoft.AspNet.TelemetryCorrelation" />
<add name="ApplicationInsightsWebTracking" type="Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" />   </httpModules>

<modules>
     <remove name="TelemetryCorrelationHttpModule" />
     <add name="TelemetryCorrelationHttpModule" type="Microsoft.AspNet.TelemetryCorrelation.TelemetryCorrelationHttpModule, Microsoft.AspNet.TelemetryCorrelation" preCondition="managedHandler" />
     <remove name="ApplicationInsightsWebTracking" />
     <add name="ApplicationInsightsWebTracking" type="Microsoft.ApplicationInsights.Web.ApplicationInsightsHttpModule, Microsoft.AI.Web" preCondition="managedHandler" />  
</modules>

• 将Connection string添加到Web.config的配置部分或添加到控制器本身。

<connectionStrings>
    <add name ="AppInsightsConn" connectionString="Data Source=******\\******;Initial Catalog=Test;Integrated Security=True"/>
</connectionStrings>

我在Controller中的代码：

我引用了MSDoc和1和2中的代码

public TelemetryClient tc;
        public ActionResult Index()
        {
            tc = new TelemetryClient();
          
            string myconn = "Data Source=******\\******;Initial Catalog=Test;Integrated Security=True";

            //var myconn = ConfigurationManager.ConnectionStrings["AppInsightsConn"].ConnectionString;
            var sqlConn = new SqlConnection(myconn);
            sqlConn.Open();

            string cmdtxt = "Select  * from MyDetails";
            var sqlCmd = new SqlCommand(cmdtxt, sqlConn);

            string dependencyType = "My SQL";
            string dependencyName = "Harshitha SQL Dependency";
            var time = DateTimeOffset.Now;

            using (var dep = tc.StartOperation<DependencyTelemetry>(dependencyName))
            {
                dep.Telemetry.Type = dependencyType;
                dep.Telemetry.Data = cmdtxt;
                dep.Telemetry.Success = true;

                var reader = sqlCmd.ExecuteReader();

                dep.Telemetry.Duration = DateTimeOffset.Now - time;
            }

            sqlConn.Close();
            return View();
        }

Application Insights中的跟踪：

依赖项：