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

Using the MariaDBDataReader

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

C#

string connectionString = "User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;";

using (MariaDBConnection connection = new MariaDBConnection(connectionString)) {
  MariaDBCommand cmd = new MariaDBCommand("SELECT * FROM Orders", connection);
  
  MariaDBDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "User=myUser;Password=myPassword;Database=NorthWind;Server=myServer;Port=3306;"

Using connection As New MariaDBConnection(connectionString)
  Dim cmd As New MariaDBCommand("SELECT * FROM Orders", connection)

  Dim rdr As MariaDBDataReader = cmd.ExecuteReader()

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