Infrastructure,
Simplified.

using Kanject.Core.NoSqlDatabase;

public class ProductRepository(INoSqlDatabase db)
{
    public Task<IReadOnlyList<Product>> GetByCategoryAsync(string category)
        => db.QueryAsync<Product>(
            partitionKey: $"category#{category}",
            sortKeyPrefix: "product#",
            limit: 20);

    public Task CreateAsync(Product product)
        => db.PutAsync(product);
}

// That's it. Credentials, region, marshalling, retries —
// all wired via AddDynamoNoSqlDatabase() in Program.cs.

using Amazon;
using Amazon.DynamoDBv2;
using Amazon.DynamoDBv2.Model;
using Amazon.Runtime;

var credentials = new BasicAWSCredentials(
    Environment.GetEnvironmentVariable("AWS_ACCESS_KEY_ID"),
    Environment.GetEnvironmentVariable("AWS_SECRET_ACCESS_KEY"));

var client = new AmazonDynamoDBClient(credentials,
    new AmazonDynamoDBConfig { RegionEndpoint = RegionEndpoint.EUWest1 });

// Query products by category
var queryRequest = new QueryRequest
{
    TableName = "products",
    KeyConditionExpression = "pk = :pk AND begins_with(sk, :sk)",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":pk", new AttributeValue { S = "category#electronics" } },
        { ":sk", new AttributeValue { S = "product#" } },
    },
    Limit = 20,
};

var response = await client.QueryAsync(queryRequest);
var products = new List<Product>();
foreach (var item in response.Items)
{
    products.Add(new Product
    {
        Id    = item["id"].S,
        Name  = item["name"].S,
        Price = decimal.Parse(item["price"].N),
        Stock = int.Parse(item["stock"].N),
    });
}

// Write a new product (manual marshalling)
await client.PutItemAsync(new PutItemRequest
{
    TableName = "products",
    Item = new Dictionary<string, AttributeValue>
    {
        { "pk",    new AttributeValue { S = "category#electronics" } },
        { "sk",    new AttributeValue { S = "product#001" } },
        { "id",    new AttributeValue { S = "product#001" } },
        { "name",  new AttributeValue { S = "Widget Pro" } },
        { "price", new AttributeValue { N = "99.99" } },
        { "stock", new AttributeValue { N = "42" } },
    },
});