Querying Using the DataReader

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

Using The NetSuiteDataReader

The NetSuiteDataReader retrieves data faster than the NetSuiteDataAdapter because it can retrieve data in pages. As you read data from the NetSuiteDataReader, it will periodically request the next page of results from the data source, if required. This causes results to be returned at a faster rate. The example below selects all the columns from the Account table:

C#

string connectionString = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;";
using (NetSuiteConnection connection = new NetSuiteConnection(connectionString)) {
  NetSuiteCommand cmd = new NetSuiteCommand("SELECT * FROM Account", connection);
  
  NetSuiteDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;Offline=false;"
Using connection As New NetSuiteConnection(connectionString)
  Dim cmd As New NetSuiteCommand("SELECT * FROM Account", connection)

  Dim rdr As NetSuiteDataReader = cmd.ExecuteReader()

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