👁 Image
MySql.Data.OpenTelemetry 9.7.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 enables telemetry capabilities. 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

 using MySql.Data.MySqlClient;
 using OpenTelemetry;
 using OpenTelemetry.Resources;
 using OpenTelemetry.Trace;

 // Create the tracer provider and add Connector/NET as a source from telemetry data.
 var tracerProvider = Sdk.CreateTracerProviderBuilder()
 .AddConnectorNet()
 .ConfigureResource(resource => resource.AddService("connector-net"))
 .Build();

 // From this point on you can use MySql.Data as usual.
 // The internal implementation of OpenTelemetry is now enabled.

 // Set the correct values for your server, user, password and database name.
 MySqlConnection myConnection;
 var myConnectionString = "server=127.0.0.1;uid=root;pwd=test;database=sakila";
 var customerId = 10;

 try
 {
 // Open a connection.
 myConnection = new MySqlConnection(myConnectionString);
 myConnection.Open();

 // Create a MySQL command and set the SQL statement with parameters.
 MySqlCommand myCommand = new MySqlCommand();
 myCommand.Connection = myConnection;
 myCommand.CommandText = @"SELECT * FROM customer WHERE customer_id = @customerId;";
 myCommand.Parameters.AddWithValue("@customerId", customerId);

 // Execute the command and read the results.
 using (var myReader = myCommand.ExecuteReader())
 {
 while (myReader.Read())
 {
 var id = myReader.GetInt32("customer_id");
 var firstName = myReader.GetString("first_name");
 var lastName = myReader.GetString("last_name");
 // ...
 }
 }
 myConnection.Close();
 }
 catch (MySqlException ex)
 {
 Console.WriteLine(ex.Message);
 }

Related Packages

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

Licensing

Please refer to files README and LICENSE, available in the Connector/NET GitHub repository, and Legal Notices in documentation for further details.

Security

Oracle values the independent security research community and believes that responsible disclosure of security vulnerabilities helps us ensure the security and privacy of all our users. Please refer to the security guidelines document for additional information.

Contributing

We greatly appreciate feedback from our users, including bug reports and code contributions. Your input helps us improve, and we thank you for any issues you report or code you contribute. Please refer to the contributing guidelines document for additional information.

Additional Resources

• MySQL Connector/NET GitHub
• MySQL Connector/NET Developer Guide
• MySQL Connector/NET API
• MySQL NuGet
• MySQL Connector/NET and C#, Mono, .Net Forum
• #connectors channel on MySQL Community Slack (Sign-up required if you do not have an Oracle account.)
• @MySQL on X.
• MySQL Blog.
• MySQL Connectors Blog archive.
• MySQL Newsletter.
• MySQL Bugs Tracking System.

For more information about this and other MySQL products, please visit MySQL Contact & Questions.