Querying with the DataReader
The CData ADO.NET Provider for Amazon DynamoDB implements two ADO.NET interfaces you can use to retrieve data from Amazon DynamoDB: AmazonDynamoDBDataAdapter and AmazonDynamoDBDataReader objects. Whereas AmazonDynamoDBDataAdapter objects retrieve a single result set of all the data that matches a query, AmazonDynamoDBDataReader objects fetch data in subset increments as needed.
Using the AmazonDynamoDBDataReader
The AmazonDynamoDBDataReader retrieves data faster than the AmazonDynamoDBDataAdapter because it can retrieve data in pages. As you read data from the AmazonDynamoDBDataReader, it periodically requests the next page of results from the data source, if required. This causes results to be returned at a faster rate. The following example selects all the columns from the Account table:
C#
string connectionString = "AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;"; using (AmazonDynamoDBConnection connection = new AmazonDynamoDBConnection(connectionString)) { AmazonDynamoDBCommand cmd = new AmazonDynamoDBCommand("SELECT * FROM Account", connection); AmazonDynamoDBDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["Id"], rdr["Name"])); } }
VB.NET
Dim connectionString As String = "AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;" Using connection As New AmazonDynamoDBConnection(connectionString) Dim cmd As New AmazonDynamoDBCommand("SELECT * FROM Account", connection) Dim rdr As AmazonDynamoDBDataReader = cmd.ExecuteReader() While rdr.Read() Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("Id"), rdr("Name"))) End While End Using