//public void Execute(System.Data.CommandType commandType, string query, ParameterType[] parameters, ReadRow rowMethod)
//{
// Execute(ConnectionStringSet, commandType, query, parameters, rowMethod);
//}
//public void Execute(string connectionString, string query, ParameterType[] parameters, ReadRow rowMethod)
//{
// Execute(connectionString, System.Data.CommandType.StoredProcedure, query, parameters, rowMethod);
//}
public void Execute(string connectionString, System.Data.CommandType commandType, string query, ParameterType[] parameters, ReadRow rowMethod)
{
using (var connection = new ConnectionType())
using (var command = new CommandType())
{
command.Connection = connection;
command.CommandText = query;
command.CommandType = commandType;
if (parameters != null)
{
Array.ForEach(parameters, p => command.Parameters.Add(p));
}
connection.ConnectionString = connectionString;
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
if (rowMethod != null)
{
rowMethod(reader);
}
}
}
}
}
public void Execute(string connectionString, string query, ParameterType[] parameters, ReadRow rowMethod)
{
Execute(connectionString, System.Data.CommandType.StoredProcedure, query, parameters, rowMethod);
}
public void Execute(string query, ParameterType[] parameters, ReadRow rowMethod)
{
Execute(ConnectionStringSet, System.Data.CommandType.StoredProcedure, query, parameters, rowMethod);
//writeLog(query, parameters);
}
public void Execute(System.Data.CommandType commandType, string query, ParameterType[] parameters, ReadRow rowMethod)
{
Execute(ConnectionStringSet, commandType, query, parameters, rowMethod);
}
