Querying Using the DataReader

RSSBus ADO.NET Provider for Facebook offers two ways to retrieve data from Facebook: FacebookDataAdapter objects and FacebookDataReader objects. Each object accomplishes the same task -- retrieving data -- but does so in a different way. Whereas FacebookDataAdapter objects retrieve all the data that matches a query wholesale, FacebookDataReader objects fetch data in subset increments as they are needed.

Using The FacebookDataReader

In this example, we use a FacebookDataReader to get data from Facebook. The FacebookDataReader retrieves data faster than the FacebookDataAdapter because it can retrieve data in pages. As you read data from the FacebookDataReader, 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 Statuses table:

C#

FacebookCommand cmd = new FacebookCommand("SELECT * FROM Statuses", connection);
  
FacebookDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim cmd As New FacebookCommand("SELECT * FROM Statuses", connection)

Dim rdr As FacebookDataReader = cmd.ExecuteReader()

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