ADO.NET Provider for Alfresco

Build 21.0.7930

Querying with the DataReader

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

Using the AlfrescoDataReader

The AlfrescoDataReader retrieves data faster than the AlfrescoDataAdapter because it can retrieve data in pages. As you read data from the AlfrescoDataReader, 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 Alfresco table:


string connectionString = "ConnectionProperty1=Value1;ConnectionProperty2=Value2";

using (AlfrescoConnection connection = new AlfrescoConnection(connectionString)) {
  AlfrescoCommand cmd = new AlfrescoCommand("SELECT * FROM Alfresco", connection);
  AlfrescoDataReader rdr = cmd.ExecuteReader();

  while (rdr.Read()) {
    Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["DBID"], rdr["Column1"]));


Dim connectionString As String = "ConnectionProperty1=Value1;ConnectionProperty2=Value2"

Using connection As New AlfrescoConnection(connectionString)
  Dim cmd As New AlfrescoCommand("SELECT * FROM Alfresco", connection)

  Dim rdr As AlfrescoDataReader = cmd.ExecuteReader()

  While rdr.Read()
    Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("DBID"), rdr("Column1")))
  End While
End Using

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930