Azure / Azure/data-api-builder

Optimize the SQL DB query in Health Endpoint

Open
#2,638 0 comments 1 reaction 1 assignee Claimed by @Aniruddh25 View on GitHub
health-endpoint refactor
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.