Add 'MongoDB.Driver.Core.Extensions.DiagnosticSources' Support

[justurbo]

Feature Request

Add MongoDB Diagnostics as source to Auto Instrumentation.

I've set up observability of a C# .NET Core app within a Kubernetes cluster using a self-hosted Grafana LGTM (without Mimir) stack. OpenTelemetry sends data to Prometheus and is later viewed in a Grafana Tempo dashboard.

1. Install kube-prometheus-stack
2. Install opentelemetry-operator
3. Add Kubernetes CDR OpenTelemetry Collector
4. Add Kubernetes CDR OpenTelemetry .NET AutoInstrumentation
5. Add .NET OpenTelemetry.AutoInstrumentation package
6. Add .NET MongoDB.Driver.Core.Extensions.DiagnosticSource package

✅ Expectation MongoDB traces are seen in the OpenTelemetry request trace.

❌ Reality MongoDB activity is invisible to Grafana Tempo:

[RassK]

Doesn't byte code instrumentation work for you?