Azure / Azure/data-api-builder
Optimize the SQL DB query in Health Endpoint
- Dominant language
- C#
- Stars
- 1.5k
- Forks
- 370
- Avg merge
- 3d 17h
- Merged PRs (30d)
- 8
Description
Try `QueryExecutor ` to optimize the SQL DB query instead of
```
using (SqlConnection connection = new(connectionString))
{
try
{
SqlCommand command = new(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
LogTrace("The health check query for datasource executed successfully.");
reader.Close();
}
catch (Exception ex)
{
LogTrace($"An exception occurred while executing the health check query: {ex.Message}");
errorMessage = ex.Message;
}
}
```
Contributor guide
Assessment
This issue has not been assessed yet.