Apm-agent-dotnet: Support Instrumentation of MySQL.Data DB Client

[bliles]

Is your feature request related to a problem? Please describe.
I would like to be able to have instrumentation of database queries using Dapper and MySQL, currently the only db client supported is MS SqlClient unless you are using EF or EFCore.

Describe the solution you'd like
I would like a package similar to ElasticApm.SqlClient for MySQL.Data DB client.

Describe alternatives you've considered
I've considered trying to build this myself.

Additional context
Appreciate all of the work that goes into APM, it already supports most of our stack with the exception of the DB layer.

[russcam]

Hey @bliles,

Thanks for opening. This is something that we would like to support in future. It's likely that auto instrumentation for MySQL would be implemented with a profiler using the runtime profiling APIs, which we're currently investigating.

[dannystommen]

@russcam Do you have any expectations when will be implemented?

[russcam]

@dannystommen I don't have a timeline for when this will be implemented that I can share. It is a priority for us to be able to instrument ADO.NET providers in general.

[MeijerM1]

Could this be added to the 8.0 milestone? I feel supporting ADO.NET providers would be a great addition.

[russcam]

@MeijerM1 thanks for your interest. ADO.NET provider integrations will be part of https://github.com/elastic/apm-agent-dotnet/issues/1522

[MeijerM1]

@russcam Thanks for the reply.

Maybe you could close this issue with a reference to the new one?
That could avoid some confusion.

[russcam]

Closing this in favour of #1522.