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

Using the Sage50UKDataReader

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

C#

string connectionString = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;";

using (Sage50UKConnection connection = new Sage50UKConnection(connectionString)) {
  Sage50UKCommand cmd = new Sage50UKCommand("SELECT * FROM TradingAccounts", connection);
  
  Sage50UKDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "URL=http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59};User=Manager;Password=xxxxxx;"

Using connection As New Sage50UKConnection(connectionString)
  Dim cmd As New Sage50UKCommand("SELECT * FROM TradingAccounts", connection)

  Dim rdr As Sage50UKDataReader = cmd.ExecuteReader()

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