ADO.NET Provider for Splunk

Build 24.0.8963

Querying with the DataReader

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

Using the SplunkDataReader

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

C#

string connectionString = "user=MyUserName;password=MyPassword;URL=MyURL;";

using (SplunkConnection connection = new SplunkConnection(connectionString)) {
  SplunkCommand cmd = new SplunkCommand("SELECT * FROM DataModels", connection);
  
  SplunkDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "user=MyUserName;password=MyPassword;URL=MyURL;"

Using connection As New SplunkConnection(connectionString)
  Dim cmd As New SplunkCommand("SELECT * FROM DataModels", connection)

  Dim rdr As SplunkDataReader = cmd.ExecuteReader()

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963