/// <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);
}
