tencent cloud

dotnet new web

dotnet add package MySqlConnector;
dotnet add package Microsoft.Extensions.Logging.Abstractions; 

{
  "$schema": "http://json.schemastore.org/launchsettings.json",
  "profiles": {
    "http": {
      "commandName": "Project",
      "dotnetRunMessages": true,
      "launchBrowser": true,
      "applicationUrl": "http://localhost:8080",
      "environmentVariables": {
        "ASPNETCORE_ENVIRONMENT": "Development"
      }
    }
  }
}

using MySqlConnector;

var builder = WebApplication.CreateBuilder(args);
var app = builder.Build();

app.MapGet("/", () => "Hello World!");

app.MapGet("/todo", () =>
{
    string connectionString = "server=localhost;port=3306;User Id=root;password=;Database=MyDB";

    using (MySqlConnection myConnnect = new MySqlConnection(connectionString))
    {
        try
        {
            myConnnect.Open();
            using (MySqlCommand myCmd = new MySqlCommand("select * from MyTable", myConnnect))
            {
                using (MySqlDataReader reader = myCmd.ExecuteReader())
                {
                    List<Int32> results = new List<Int32>();
                    while (reader.Read())
                    {
                        // Assume we only process data IDs in the first column.
                        results.Add(reader.GetInt32(0));
                    }
                    return "ids:" + string.Join(", ", results);
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Database operation error: {ex.Message}");
            return "Database operation error";
        }
    }
});

app.Run();

curl -L -O https://github.com/open-telemetry/opentelemetry-dotnet-instrumentation/releases/latest/download/otel-dotnet-auto-install.sh

chmod -x otel-dotnet-auto-install.sh

sh ./otel-dotnet-auto-install.sh

chmod -x $HOME/.otel-dotnet-auto/instrument.sh

export OTEL_TRACES_EXPORTER=otlp \\
  OTEL_METRICS_EXPORTER=none \\
  OTEL_LOGS_EXPORTER=none \\
  OTEL_SERVICE_NAME=<service-name> \\ # Replace <service-name> with the actual service name.
  OTEL_EXPORTER_OTLP_PROTOCOL=grpc \\
  OTEL_EXPORTER_OTLP_ENDPOINT=<endpoint> \\ # Replace with the access point obtained in Step 1.
  OTEL_RESOURCE_ATTRIBUTES="token=<token>" # Replace with the token obtained in step 1.
. $HOME/.otel-dotnet-auto/instrument.sh

dotnet build
dotnet run

http://localhost:8080
http://localhost:8080/todo

dotnet add package OpenTelemetry.Instrumentation.AspNetCore

var serviceName = "<service-name>"; // Replace <service-name> with the actual service name.
using var tracerProvider = Sdk.CreateTracerProviderBuilder()
    .AddSource(serviceName)
    .SetResourceBuilder(
    ResourceBuilder.CreateDefault().AddService(serviceName)
    .AddAttributes(new Dictionary<string, object>
    {
        ["token"] = "<token>", // Replace <token> with the token obtained in the previous step.
        ["host.name"] = "<host>" // Replace <host> with the actual hostname.
    }))
    .AddOtlpExporter(opt =>
    {
        opt.Endpoint = new Uri("<endpoint>"); // Replace <endpoint> with the access point information obtained in the previous step.
        opt.Protocol = OtlpExportProtocol.Grpc;
    })
    .Build();

var MyActivitySource = new ActivitySource(serviceName);

using var activity = MyActivitySource.StartActivity("SayHello");
// Add the Activity Tag.
activity?.SetTag("key", "3.1415");
// Add an Event to the Activity.
activity?.AddEvent(new("something happened"));