internal void SQLReaderForEach(string SQL, ServiceReaderAction action, params DbParameter[] @params) { RaiseServiceMessage("Executing query..."); using (new CodeTimer(String.Format("SQLReaderForEach '{0}'", SQL))) { Logger.Debug("Calling stored procedure (reader): {0}({1})", SQL, GetParamsString(@params)); Command((con, cmd) => { cmd.CommandText = SQL; cmd.CommandType = CommandType.Text; if (User.InTransaction && User.CurrentTransaction != null) { cmd.Transaction = User.CurrentTransaction; } foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { RaiseServiceMessage("Fetching records..."); int count = 0; while (reader.Read()) { if (action != null) { action(reader); } if (++count % 1000 == 0) { RaiseServiceMessage("{0} records retrieved", count); } } } }); } }
internal void StoredProcReaderFirst(string proc, ServiceReaderAction action, params DbParameter[] @params) { using (new CodeTimer(String.Format("StoredProcReaderFirst '{0}'", proc))) { Logger.Debug("Calling stored procedure (reader): {0}({1})", proc, GetParamsString(@params)); Command((con, cmd) => { User.ConnectionProvider.StoredProcReaderFirst(User, cmd, proc, action, (msg) => RaiseServiceMessage(msg), @params); }); } }
protected void SelectReader(string sql, ServiceReaderAction action, params SQLiteParameter[] @params) { Logger.Debug("Executing SQLite SelectReader: {0}", sql); using (new CodeTimer("SQLite SelectReader")) { Command((cmd) => { cmd.CommandText = sql; foreach (SQLiteParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { if (action != null) { action(reader); } } } }); } }
public void StoredProcReaderFirst(User user, DbCommand cmd, string proc, ServiceReaderAction action, Action <string> message, params DbParameter[] @params) { cmd.CommandText = proc; cmd.CommandType = CommandType.StoredProcedure; if (user.InTransaction && user.CurrentTransaction != null) { cmd.Transaction = user.CurrentTransaction; } foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { if (action != null) { action(reader); } } } }
public override void StoredProcReaderFirst(User user, System.Data.Common.DbCommand command, string proc, ServiceReaderAction action, Action <string> message, params System.Data.Common.DbParameter[] @params) { }
public void StoredProcReaderFirst(User user, DbCommand cmd, string proc, ServiceReaderAction action, Action<string> message, params DbParameter[] @params) { cmd.CommandText = proc; cmd.CommandType = CommandType.StoredProcedure; if (user.InTransaction && user.CurrentTransaction != null) { cmd.Transaction = user.CurrentTransaction; } foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { if (action != null) { action(reader); } } } }
void IConnectionProvider.StoredProcReaderForEach(User user, DbCommand cmd, string proc, ServiceReaderAction action, Action<string> message, params DbParameter[] @params) { cmd.CommandText = proc; cmd.CommandType = CommandType.StoredProcedure; if (user.InTransaction && user.CurrentTransaction != null) { cmd.Transaction = user.CurrentTransaction; } foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { message("Fetching records..."); int count = 0; while (reader.Read()) { if (action != null) { action(reader); } if (++count % 1000 == 0) { message(String.Format("{0} records retrieved", count)); } } } }
void IConnectionProvider.StoredProcReaderForEach(User user, DbCommand cmd, string proc, ServiceReaderAction action, Action <string> message, params DbParameter[] @params) { cmd.CommandText = proc; cmd.CommandType = CommandType.StoredProcedure; if (user.InTransaction && user.CurrentTransaction != null) { cmd.Transaction = user.CurrentTransaction; } foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { message("Fetching records..."); int count = 0; while (reader.Read()) { if (action != null) { action(reader); } if (++count % 1000 == 0) { message(String.Format("{0} records retrieved", count)); } } } }
public abstract void StoredProcReaderForEach(User user, DbCommand command, string proc, ServiceReaderAction action, Action<string> message, params DbParameter[] @params);
protected void SelectReader(DbConnection conn, string sql, ServiceReaderAction action, params DbParameter[] @params) { Logger.Debug("Executing SQLite SelectReader: {0}", sql); using (new CodeTimer("SQLite SelectReader")) { Command(conn, (c, cmd) => { cmd.CommandText = sql; foreach (DbParameter param in @params) { cmd.Parameters.Add(param); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { if (action != null) { action(reader); } } } }); } }
public abstract void StoredProcReaderForEach(User user, DbCommand command, string proc, ServiceReaderAction action, Action <string> message, params DbParameter[] @params);