/// <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); } } } }