SQL Server: Consider introducing EF and its version into the connection string's Application Name

[roji]

In order to get information about EF usage, we'll consider injecting EF information into the Application Name of the connection string passed to SqlClient. This isn't ideal - we've discussed the possibility of a separate API point in SqlClient to allow EF (and similar layers) to add "user-agent" information.

/cc @saurabh500 @cheenamalhotra @perrysk-msft - is there an issue tracking the new SqlClient API on your side?

/cc @SamMonoRT

[cheenamalhotra]

We've been discussing internally on this, and most likely will come up with a new API for the same, to prevent inconsistent usage of Application Name from exploiting telemetry data.

We're drafting out API structure and will share details soon for review.

[roji]

SqlClient-side user agent PRs: dotnet/SqlClient#3451, dotnet/SqlClient#3489