public async Task RemoveUsersFromSession(int sessionId) { //Get the questionnaire by its Id await _db.BulkDeleteAsync <SessionUser>(query => query .Where($"{nameof(SessionUser.SessionId):C} = @sessionId") .WithParameters(new { sessionId })); }
public async Task <int> DeleteAllTokens(int id) { using (IDbConnection dbConnection = Connection) { dbConnection.Open(); return(await dbConnection.BulkDeleteAsync <AccountToken>(statement => statement.Where($"{nameof(AccountToken.AccountId):C}={id}"))); } }
public static async Task <int> BulkDeleteAsync <TEntity>(IDbConnection db, Action <IConditionalBulkSqlStatementOptionsBuilder <TEntity> > statementOptions = null) { // using (await Sync.LockAsync()) { try { return(await db.BulkDeleteAsync(statementOptions)); } catch (Exception e) { Logger.Error($"DBError, {e}"); } return(-1); } }