string apiKey = "<Your DynamoDB Api Key>";
string secret = "<Your DynamoDB Api Secret>";

var connection = new PrimarSqlConnection(new PrimarSqlConnectionStringBuilder
{
    AccessKey = apiKey,
    AccessSecretKey = secret,
    AwsRegion = AwsRegion.APNortheast2
});

connection.Open();

string query = "SELECT * FROM table";

var command = connection.CreateDbCommand(query);
var dbDataReader = command.ExecuteReader();

while (dbDataReader.Read())
{
    // ...
}