ADO.NET Provider for DocuSign

Build 23.0.8839

Querying with the DataReader

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

Using the DocuSignDataReader

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


string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333";

using (DocuSignConnection connection = new DocuSignConnection(connectionString)) {
  DocuSignCommand cmd = new DocuSignCommand("SELECT * FROM Account", connection);
  DocuSignDataReader rdr = cmd.ExecuteReader();

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


Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyClientId;OAuthClientSecret=MyClientSecret;CallbackURL=http://localhost:33333"

Using connection As New DocuSignConnection(connectionString)
  Dim cmd As New DocuSignCommand("SELECT * FROM Account", connection)

  Dim rdr As DocuSignDataReader = cmd.ExecuteReader()

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

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