Activity from SQL instrumentation replaces Activity.Current from the call site

[pardahlman]

Bug Report

List of all OpenTelemetry NuGetpackages and version that you are using:

• OpenTelemetry.Instrumentation.SqlClient 1.0.0-rc9.9

Runtime version:

• net6.0

Symptom

After executing an SQL command, Activity.Current is replaced by OpenTelemetry.Instrumentation.SqlClient.Execute.

What is the expected behavior?

I expect Activity.Current to be reset to the value it had before the SQL command is executed.

What is the actual behavior?

Activity.Current is replaced by OpenTelemetry.Instrumentation.SqlClient.Execute

Reproduce

See self-contained project: https://github.com/pardahlman/otel-repro

[tbajkacz]

I'm experiencing a similar issue using the OpenTelemetry.Instrumentation.EntityFrameworkCore 1.0.0-beta.3 package

[CaffeineDaemon]

I am using OpenTelemetry.Instrumentation.SqlClient 1.0.0-rc9.10 and OpenTelemetry.Instrumentation.EntityFrameworkCore 1.0.0-beta2 and had the same issue, but removing only the EntityFrameworkCore Instrumentation package solved it, so i would assume the issue comes from this package and not from the SQL client instrumentation.

[martinjt]

I've tested this and I'm not seeing this issue. Given the issue is over a year old, I suspect something has resolved this.