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

Using the SharePointDataReader

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

C#

string connectionString = "User=MyUserAccount;Password=MyPassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite;";

using (SharePointConnection connection = new SharePointConnection(connectionString)) {
  SharePointCommand cmd = new SharePointCommand("SELECT * FROM Calendar", connection);
  
  SharePointDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "User=MyUserAccount;Password=MyPassword;Auth Scheme=NTLM;URL=http://sharepointserver/mysite;"

Using connection As New SharePointConnection(connectionString)
  Dim cmd As New SharePointCommand("SELECT * FROM Calendar", connection)

  Dim rdr As SharePointDataReader = cmd.ExecuteReader()

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