I have a Blazor server application with 2 databases it calls via Entity Frameworks. One is the Identity Library DB. The other is my application DB.
When I go in to Application Insights and:
- Click on the Application map
- Click on the SQL Server (2)
- Click Investigate performance
It now under Dependency Name lists the 2 databases.
- I select one of the dependencies
- I click Drill into
Now over on the right it has Select a sample dependency
If I click on one from the Identity Library database, on the right it has:
- Dependency Properties
- Custom properties
- Command – this has the query run
- Related Items
But if I click on one from the application database, then over on the right, for the command, it has the following:
louishowe.database.windows.net,1433 | Application_2024_04_25
That’s the server & database. But no query. Why not? What do I have to do so Application Insights can show me the actual queries?