ADO.NET Provider for Amazon Athena

Build 23.0.8839

Executing DbCommands

The following section shows how to execute commands using ADO.NET base classes like DbCommand and DbDataAdapter.

Executing Commands to Amazon Athena

The following code executes a "SELECT *" query to Amazon Athena, given an existing DbConnection object.

using (connection) {

  // Create the DbCommand.
  DbCommand command = factory.CreateCommand();
  command.CommandText = 
    "SELECT * FROM [AwsDataCatalog].[sampledb].Customers";

  command.Connection = connection;

  // Create the DbDataAdapter.
  DbDataAdapter adapter = factory.CreateDataAdapter();
  adapter.SelectCommand = command;

  // Fill the DataTable.
  DataTable table = new DataTable();
  adapter.Fill(table);

  //  Display each row and column value.
  foreach (DataRow row in table.Rows) {
    foreach (DataColumn column in table.Columns) {
      Console.WriteLine(row[column]);
    }
  }
} 

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839