/// <summary>
/// Executes data reader of command object with specified SQL query
/// </summary>
/// <param name="cmdText">SQL query text.</param>
/// <param name="paramsList">Parameters list.</param>
/// <param name="callback">Callback method while moving through the records.</param>
/// <returns></returns>
public void ExecuteReader(string cmdText, SqliteParameterCollection paramsList, DataReaderCallbackDelegate callback)
{
using (SqliteCommand cmd = GetCommand(cmdText, paramsList))
{
using (SqliteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// Need to check if callback is null?
if (callback != null)
{
callback(reader);
}
}
}
}
}
/// <summary>
/// Executes data reader of command object with specified SQL query
/// </summary>
/// <param name="cmdText">SQL query text.</param>
/// <param name="paramsList">Parameters list.</param>
/// <param name="callback">Callback method while moving through the records.</param>
/// <returns></returns>
public void ExecuteReader(string cmdText, SqliteParameterCollection paramsList, DataReaderCallbackDelegate callback)
{
using (SqliteCommand cmd = GetCommand(cmdText, paramsList))
{
using (SqliteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
// Need to check if callback is null?
if (callback != null) callback(reader);
}
}
}
}
