csharp-sdk

Here's a C# code snippet that demonstrates how to use the Model Context Protocol SDK to connect to a server and retrieve data:

```csharp
using System;
using Microsoft.ModelContextProtocol.Sdk;
using Microsoft.Extensions.Logging;

class Program
{
    static async Task Main(string[] args)
    {
        var loggerFactory = LoggerFactory.Create(builder =>
        {
            builder.AddConsole();
        });
        
        var logger = loggerFactory.CreateLogger<Program>();
        
        try
        {
            var connectionString = "Server=myServer;Database=myDB;User Id=myUser;Password=myPassword;";
            using (var connection = new ModelContextProtocolConnection(connectionString))
            {
                await connection.OpenAsync();
                
                var command = new ModelContextProtocolCommand("SELECT * FROM Customers", connection);
                using (var reader = await command.ExecuteReaderAsync())
                {
                    while (await reader.ReadAsync())
                    {
                        Console.WriteLine($"Customer ID: {reader["CustomerID"]}, Name: {reader["Name"]}");
                    }
                }
            }
        }
        catch (Exception ex)
        {
            logger.LogError(ex, "An error occurred while retrieving data");
        }
    }
}
```

This code connects to a server named 'myServer' and retrieves data from the 'Customers' table. It includes error handling and logging for debugging purposes. The code is compatible with .NET 6.0 and follows best practices for secure connections.