ADO.NET Provider for Microsoft Dynamics 365

Build 22.0.8462

Querying with the DataReader

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

Using the Dynamics365DataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.operations.dynamics.com/;Edition=Sales;";

using (Dynamics365Connection connection = new Dynamics365Connection(connectionString)) {
  Dynamics365Command cmd = new Dynamics365Command("SELECT * FROM GoalHeadings", connection);
  
  Dynamics365DataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OrganizationUrl=https://myaccount.operations.dynamics.com/;Edition=Sales;"

Using connection As New Dynamics365Connection(connectionString)
  Dim cmd As New Dynamics365Command("SELECT * FROM GoalHeadings", connection)

  Dim rdr As Dynamics365DataReader = cmd.ExecuteReader()

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462