MySQL/MySql.Data.OpenTelemetryv8.3.0

About

MySQL provides connectivity for client applications developed in .NET compatible programming languages with MySQL Connector/NET through a series of packages.

MySql.Data.OpenTelemetry activates telemetry capabilities when the target MySQL server is configured to support telemetry. It is compatible with .NET 6.0+ and must be used alongside the MySql.Data package. An OpenTelemetry SDK is required.

More information at [MySQL Connector/NET documentation] (https://dev.mysql.com/doc/connector-net/en/).

How to use

//create the tracer provider and add Connector/NET as a source from telemetry data. using var tracerProvider = Sdk.CreateTracerProviderBuilder() .AddConnectorNet() .ConfigureResource(resource => resource.AddService("connector-net")) .Build(); //use MySql.Data as usual, the internal implementation of OpenTelemetry is now enabled. MySql.Data.MySqlClient.MySqlConnection myConnection; string myConnectionString; //set the correct values for your server, user, password and database name myConnectionString = "server=127.0.0.1;uid=root;pwd=12345;database=test"; try { myConnection = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString); //open a connection myConnection.Open(); // create a MySQL command and set the SQL statement with parameters MySqlCommand myCommand = new MySqlCommand(); myCommand.Connection = myConnection; myCommand.CommandText = @"SELECT * FROM clients WHERE client_id = @clientId;"; myCommand.Parameters.AddWithValue("@clientId", clientId); // execute the command and read the results using var myReader = myCommand.ExecuteReader() { while (myReader.Read()) { var id = myReader.GetInt32("client_id"); var name = myReader.GetString("client_name"); // ... } } myConnection.Close(); } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show(ex.Message); }

Related Packages

• Core package: MySql.Data
• Entity Framework Core: MySql.EntityFrameworkCore