/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
internal static string GetDeleteAllText(DeleteAllRequest request)
{
if (cache.TryGetValue(request, out var commandText) == false)
{
var statementBuilder = EnsureStatementBuilder(request.Connection, request.StatementBuilder);
commandText = statementBuilder.CreateDeleteAll(new QueryBuilder(),
request.Name,
request.Hints);
cache.TryAdd(request, commandText);
}
return(commandText);
}
/// <summary>
/// Gets a command text from the cache for the <see cref="DbConnectionExtension.DeleteAll{TEntity}(IDbConnection, int?, IDbTransaction, ITrace, IStatementBuilder)"/> operation.
/// </summary>
/// <typeparam name="TEntity">The type of the target entity.</typeparam>
/// <param name="request">The request object.</param>
/// <returns>The cached command text.</returns>
public static string GetDeleteAllText <TEntity>(DeleteAllRequest request)
where TEntity : class
{
var commandText = (string)null;
if (m_cache.TryGetValue(request, out commandText) == false)
{
var statementBuilder = EnsureStatementBuilder(request.Connection, request.StatementBuilder);
commandText = statementBuilder.CreateDeleteAll(queryBuilder: new QueryBuilder <TEntity>());
m_cache.TryAdd(request, commandText);
}
return(commandText);
}
/// <summary>
/// Deletes all the data from the database.
/// </summary>
/// <param name="connection">The connection object to be used.</param>
/// <param name="request">The actual <see cref="DeleteAllRequest"/> object.</param>
/// <param name="commandTimeout">The command timeout in seconds to be used.</param>
/// <param name="transaction">The transaction to be used.</param>
/// <param name="trace">The trace object to be used.</param>
/// <returns>The number of rows affected by the execution.</returns>
internal static async Task <int> DeleteAllAsyncInternalBase(this IDbConnection connection,
DeleteAllRequest request,
int?commandTimeout = null,
IDbTransaction transaction = null,
ITrace trace = null)
{
// Validate
InvokeValidatorValidateDeleteAllAsync(connection);
// Variables
var commandType = CommandType.Text;
var commandText = CommandTextCache.GetDeleteAllText(request);
// Before Execution
if (trace != null)
{
var cancellableTraceLog = new CancellableTraceLog(commandText, null, null);
trace.BeforeDeleteAll(cancellableTraceLog);
if (cancellableTraceLog.IsCancelled)
{
if (cancellableTraceLog.IsThrowException)
{
throw new CancelledExecutionException(commandText);
}
return(0);
}
commandText = (cancellableTraceLog.Statement ?? commandText);
}
// Before Execution Time
var beforeExecutionTime = DateTime.UtcNow;
// Actual Execution
var result = await ExecuteNonQueryAsyncInternal(connection : connection,
commandText : commandText,
param : null,
commandType : commandType,
commandTimeout : commandTimeout,
transaction : transaction,
skipCommandArrayParametersCheck : true);
// After Execution
if (trace != null)
{
trace.AfterDeleteAll(new TraceLog(commandText, null, result,
DateTime.UtcNow.Subtract(beforeExecutionTime)));
}
// Result
return(result);
}
/// <summary>
/// Deletes all the data from the database.
/// </summary>
/// <typeparam name="TEntity">The type of the data entity object.</typeparam>
/// <param name="connection">The connection object to be used.</param>
/// <param name="commandTimeout">The command timeout in seconds to be used.</param>
/// <param name="transaction">The transaction to be used.</param>
/// <param name="trace">The trace object to be used.</param>
/// <param name="statementBuilder">The statement builder object to be used.</param>
/// <returns>The number of rows affected by the execution.</returns>
internal static int DeleteAllInternal <TEntity>(this IDbConnection connection,
int?commandTimeout = null,
IDbTransaction transaction = null,
ITrace trace = null,
IStatementBuilder statementBuilder = null)
where TEntity : class
{
// Variables
var request = new DeleteAllRequest(typeof(TEntity),
connection,
statementBuilder);
// Return the result
return(DeleteAllInternalBase(connection: connection,
request: request,
commandTimeout: commandTimeout,
transaction: transaction,
trace: trace));
}
/// <summary>
/// Deletes all the data from the database in an asynchronous way.
/// </summary>
/// <param name="connection">The connection object to be used.</param>
/// <param name="tableName">The name of the target table.</param>
/// <param name="commandTimeout">The command timeout in seconds to be used.</param>
/// <param name="transaction">The transaction to be used.</param>
/// <param name="trace">The trace object to be used.</param>
/// <param name="statementBuilder">The statement builder object to be used.</param>
/// <returns>The number of rows affected by the execution.</returns>
internal static Task <int> DeleteAllAsyncInternal(this IDbConnection connection,
string tableName,
int?commandTimeout = null,
IDbTransaction transaction = null,
ITrace trace = null,
IStatementBuilder statementBuilder = null)
{
// Variables
var request = new DeleteAllRequest(tableName,
connection,
statementBuilder);
// Return the result
return(DeleteAllAsyncInternalBase(connection: connection,
request: request,
commandTimeout: commandTimeout,
transaction: transaction,
trace: trace));
}
