Could you explain the principles underlying transactional reliability in databases known as ACID?

ACID is a set of properties that guarantee reliable transactions in databases:

• Atomicity: The transaction is completed in full or not at all. If something goes wrong, all changes are rolled back.
• Consistency: The transaction transitions the database from one valid state to another, without violating any rules or constraints.
• Isolation: Parallel transactions do not affect each other as if they were executed sequentially.
• Durability: After a transaction is committed, the changes are saved and not lost even in case of failures.

Example in C# using a transaction:

using (var transaction = connection.BeginTransaction())
{
    try
    {
        // Executing multiple database operations
        command1.ExecuteNonQuery();
        command2.ExecuteNonQuery();

        transaction.Commit(); // Committing the transaction
    }
    catch
    {
        transaction.Rollback(); // Rolling back in case of error
        throw;
    }
}