using the "ScanOperator.In" for DynamoDB in ASP.NET

Question

I'm using the AWS SDK for .NET, and I'm trying to perform a "scan" operation using the "in" operator.

The ScanCondition takes in three arguments, but I'm not sure what the last argument [the values] should be.

Is it an array of strings? (this returns empty, when it should return results)
Is it a comma-delimited list of strings? (this throws an error saying it could not convert a list of strings into a string)

I've tried a number of different things, and nothing has worked.

public void GetUsers()
{
    AmazonDynamoDBClient client = new AmazonDynamoDBClient("key", "secret", Amazon.RegionEndpoint.GetBySystemName("systemEndpoint");
    DynamoDBContext context = new DynamoDBContext(client);

    var results = context.Scan<User>(new ScanCondition("ID", ScanOperator.In, list /* what goes here? */));
}

Damian Green · Accepted Answer · 2016-05-10 17:22:03Z

3

The values argument should be of type object[].

In your example, (assuming your list is of type int[] or List), it needs to be cast to type object[] first.

var objectValues = list.Select(x => (object)x).ToArray();
var results = context.Scan<User>(new ScanCondition("ID", ScanOperator.In, objectValues));

It's a known usability issue with the API. If your ID property were of type string, it would work as you'd expect.

answered May 10, 2016 at 17:22

Damian Green

7,5952 gold badges36 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chen Harel · Accepted Answer · 2013-12-05 13:14:12Z

1

As the documentation states the object needed is AttributeValueList. So you will need to wrap your strings as AttributeValues before passing them to the Scan command

answered Dec 5, 2013 at 13:14

Chen Harel

10.1k5 gold badges48 silver badges60 bronze badges

Collectives™ on Stack Overflow

using the "ScanOperator.In" for DynamoDB in ASP.NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related