Investigate direct support for OpenTelemetry tracing

[roji]

EF Core currently doesn't support OpenTelemetry, but rather traces via DiagnosticSource.

An OpenTelemetry contrib package exists for instrumenting EF Core to emit activities for command execution (containing a hard-coded translation table for the database name). We should look into providing a more 1st-class support for this.

[ben-wilson-mews]

Just adding System.Diagnostics.Activity as a keyword for anyone else searching for a similar issue. Thanks for raising this