public void ExecuteReader()
{
using (var conn = DbConnectionManager.Clone()) {
conn.Open();
QueryStart();
IDataReader reader = conn.ExecuteReader(Command, _Parameter) as IDataReader;
for (int rowNr = 0; rowNr < ReadTopX; rowNr++)
{
if (reader.Read())
{
InternalBeforeRowReadAction?.Invoke();
BeforeRowReadAction?.Invoke();
for (int i = 0; i < Actions?.Count; i++)
{
if (!reader.IsDBNull(i))
{
Actions?[i]?.Invoke(reader.GetValue(i));
}
else
{
Actions?[i]?.Invoke(null);
}
}
AfterRowReadAction?.Invoke();
InternalAfterRowReadAction?.Invoke();
}
else
{
break;
}
}
reader.Close();
QueryFinish();
}
}
public void BulkInsert(ITableData data, string tableName)
{
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
if (!DisableLogging)
{
LoggingStart(LogType.Bulk);
}
conn.BeforeBulkInsert(tableName);
conn.BulkInsert(data, tableName);
conn.AfterBulkInsert(tableName);
RowsAffected = data.RecordsAffected;
if (!DisableLogging)
{
LoggingEnd(LogType.Bulk);
}
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
}
/* Public methods */
public int ExecuteNonQuery()
{
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
if (!DisableLogging)
{
LoggingStart();
}
RowsAffected = DoSkipSql ? 0 : conn.ExecuteNonQuery(Command, Parameter);
if (!DisableLogging)
{
LoggingEnd(LogType.Rows);
}
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
return(RowsAffected ?? 0);
}
public object ExecuteScalar()
{
object result = null;
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
if (!DisableLogging)
{
LoggingStart();
}
result = conn.ExecuteScalar(Command, Parameter);
if (!DisableLogging)
{
LoggingEnd();
}
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
return(result);
}
/* Public methods */
public int ExecuteNonQuery()
{
using (var conn = DbConnectionManager.Clone()) {
conn.Open();
QueryStart();
RowsAffected = DoSkipSql ? 0 : conn.ExecuteNonQuery(Command, _Parameter);//DbConnectionManager.ExecuteNonQuery(Command);
QueryFinish(LogType.Rows);
}
return(RowsAffected ?? 0);
}
public void BulkInsert(IDataReader data, IColumnMappingCollection columnMapping, string tableName)
{
using (var conn = DbConnectionManager.Clone()) {
conn.Open();
QueryStart(LogType.Bulk);
conn.BulkInsert(data, columnMapping, tableName);
RowsAffected = data.RecordsAffected;
QueryFinish(LogType.Bulk);
}
}
public void BulkInsert(ITableData data, string tableName)
{
using (var conn = DbConnectionManager.Clone()) {
conn.Open();
QueryStart(LogType.Bulk);
conn.BeforeBulkInsert();
conn.BulkInsert(data, tableName);
conn.AfterBulkInsert();
RowsAffected = data.RecordsAffected;
QueryFinish(LogType.Bulk);
}
}
public object ExecuteScalar()
{
object result = null;
using (var conn = DbConnectionManager.Clone()) {
conn.Open();
QueryStart();
result = conn.ExecuteScalar(Command, _Parameter);
QueryFinish();
}
return(result);
}
public void BulkUpsert(ITableData data, string tableName, List <string> keys, List <string> updateFields)
{
using (var conn = DbConnectionManager.Clone())
{
conn.Open();
QueryStart(LogType.Bulk);
conn.BeforeBulkUpsert();
conn.BulkUpsert(data, tableName, keys, updateFields);
conn.AfterBulkUpsert();
RowsAffected = conn.rowsAffected;
QueryFinish(LogType.Rows);
}
}
public void ExecuteReader()
{
using (var conn = DbConnectionManager.Clone())
{
conn.Open();
QueryStart();
IDataReader reader = conn.ExecuteReader(Command, _Parameter) as IDataReader;
//for (int rowNr = 0; rowNr < ReadTopX; rowNr++)
//{
while (reader.Read())
{
InternalBeforeRowReadAction?.Invoke();
BeforeRowReadAction?.Invoke();
for (int i = 0; i < Actions?.Count; i++)
{
//if (!reader.IsDBNull(i))
//{
//string value = reader.GetValue(i).ToString();
//for (int j = 0; j < reader.FieldCount; j++)
//{
// if (String.IsNullOrEmpty(value))
// {
// value = reader.GetValue(j).ToString();
// }
// else
// {
// value += "," + reader.GetValue(j).ToString();
// }
//}
Actions?[i]?.Invoke(reader);
//}
//else
//{
// Actions?[i]?.Invoke(null);
//}
}
AfterRowReadAction?.Invoke();
InternalAfterRowReadAction?.Invoke();
}
//else
//{
// break;
//}
//}
reader.Close();
QueryFinish();
}
}
public void ExecuteReader()
{
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
if (!DisableLogging)
{
LoggingStart();
}
IDataReader reader = conn.ExecuteReader(Command, Parameter) as IDataReader;
for (int rowNr = 0; rowNr < Limit; rowNr++)
{
if (reader.Read())
{
BeforeRowReadAction?.Invoke();
for (int i = 0; i < Actions?.Count; i++)
{
if (!reader.IsDBNull(i))
{
Actions?[i]?.Invoke(reader.GetValue(i));
}
else
{
Actions?[i]?.Invoke(null);
}
}
AfterRowReadAction?.Invoke();
}
else
{
break;
}
}
reader.Close();
if (!DisableLogging)
{
LoggingEnd();
}
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
}
/* Public methods */
public int ExecuteNonQuery()
{
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
QueryStart();
RowsAffected = DoSkipSql ? 0 : conn.ExecuteNonQuery(Command, _Parameter);//DbConnectionManager.ExecuteNonQuery(Command);
QueryFinish(LogType.Rows);
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
return(RowsAffected ?? 0);
}
public object ExecuteScalar()
{
object result = null;
var conn = DbConnectionManager.Clone();
try
{
conn.Open();
QueryStart();
result = conn.ExecuteScalar(Command, _Parameter);
QueryFinish();
}
finally
{
if (!conn.LeaveOpen)
{
conn.Close();
}
}
return(result);
}