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