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

Using the EpicorERPDataReader

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

C#

string connectionString = "Service=Erp.BO.CustomerSvc;ERPInstance=MyInstance;URL=https://myaccount.epicorsaas.com;User=username;Password=password;";

using (EpicorERPConnection connection = new EpicorERPConnection(connectionString)) {
  EpicorERPCommand cmd = new EpicorERPCommand("SELECT * FROM Customers", connection);
  
  EpicorERPDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "Service=Erp.BO.CustomerSvc;ERPInstance=MyInstance;URL=https://myaccount.epicorsaas.com;User=username;Password=password;"

Using connection As New EpicorERPConnection(connectionString)
  Dim cmd As New EpicorERPCommand("SELECT * FROM Customers", connection)

  Dim rdr As EpicorERPDataReader = cmd.ExecuteReader()

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