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

Using the RedisDataReader

The RedisDataReader retrieves data faster than the RedisDataAdapter because it can retrieve data in pages. As you read data from the RedisDataReader, 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 = "Server=127.0.0.1;Password=myPassword;";

using (RedisConnection connection = new RedisConnection(connectionString)) {
  RedisCommand cmd = new RedisCommand("SELECT * FROM Customers", connection);
  
  RedisDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "Server=127.0.0.1;Password=myPassword;"

Using connection As New RedisConnection(connectionString)
  Dim cmd As New RedisCommand("SELECT * FROM Customers", connection)

  Dim rdr As RedisDataReader = cmd.ExecuteReader()

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