/// <summary> /// Checks if the given <see cref="MySqlStatement.SqlStatementType"/> affects rows in the database. /// </summary> /// <param name="statementType">A <see cref="MySqlStatement.SqlStatementType"/> value.</param> /// <returns><c>true</c> if the <see cref="MySqlStatement.SqlStatementType"/> affects rows in the database, <c>false</c> otherwise.</returns> public static bool AffectsRowsOnServer(this MySqlStatement.SqlStatementType statementType) { return(statementType == MySqlStatement.SqlStatementType.Delete || statementType == MySqlStatement.SqlStatementType.Insert || statementType == MySqlStatement.SqlStatementType.Update); }
/// <summary> /// Gets the total count of affected rows within the given list of rows with statements of a given type. /// </summary> /// <param name="rowsList">The list of <see cref="IMySqlDataRow"/> objects holding <see cref="MySqlStatement"/>s.</param> /// <param name="statementType">The type of statements to account affected rows for.</param> /// <returns>The total count of affected rows for a given statement type.</returns> public static int GetResultsCount(this List <IMySqlDataRow> rowsList, MySqlStatement.SqlStatementType statementType) { return(rowsList != null ? rowsList.Where(iMsqlRow => iMsqlRow.Statement.StatementType == statementType && iMsqlRow.Statement.AffectedRows > 0).Sum(iMsqlRow => iMsqlRow.Statement.AffectedRows) : 0); }