The CData ADO.NET Provider for Amazon S3 implements two ADO.NET interfaces you can use to retrieve data from Amazon S3: AmazonS3DataAdapter and AmazonS3DataReader objects. Whereas AmazonS3DataAdapter objects retrieve a single result set of all the data that matches a query, AmazonS3DataReader objects fetch data in subset increments as needed.

Using the AmazonS3DataAdapter

Use the adapter's Fill method to retrieve data from the data source. An empty DataTable instance is passed as an argument to the Fill method. When the method returns, the DataTable instance is populated with the queried data. Note that the AmazonS3DataAdapter is slower than the AmazonS3DataReader because the Fill method needs to retrieve all data from the data source before returning.

The following example selects the Name and OwnerId columns of the Buckets table:

C#

string connectionString = "AWSAccessKey=a123;AWSSecretKey=s123;";

using (AmazonS3Connection connection = new AmazonS3Connection(connectionString)) {
  AmazonS3DataAdapter dataAdapter = new AmazonS3DataAdapter(
  "SELECT Name, OwnerId FROM Buckets", connection);

  DataTable table = new DataTable();
  dataAdapter.Fill(table);

  Console.WriteLine("Contents of Buckets.");

  foreach (DataRow row in table.Rows) {
    Console.WriteLine("{0}: {1}", row["Name"], row["OwnerId"]);
  }
}

VB.NET

Dim connectionString As String = "AWSAccessKey=a123;AWSSecretKey=s123;"

Using connection As New AmazonS3Connection(connectionString)
  Dim dataAdapter As New AmazonS3DataAdapter("SELECT Name, OwnerId FROM Buckets", connection)

  Dim table As New DataTable()
  dataAdapter.Fill(table)

  Console.WriteLine("Contents of Buckets.")

  For Each row As DataRow In table.Rows
    Console.WriteLine("{0}: {1}", row("Name"), row("OwnerId"))
  Next
End Using