Exam 70-487 topic 1 question 22 discussion

In this scenario the answer is correct. But on my exam the second condition was another: If an error occurs while attempting to add the city, the country must be added. So I answered: Rollback("Inserted") in the second block.

Тransaction is named "Beginning". "Inserted" is the name of save point. Since the condition requires that when an error occurs, no city or country to be added, then the transaction must be Rollback to the starting point, not to the save point. So the solution is correct.

Why bother to create a save point that we never roll back to? According to this article a save point "Allows you to create a save point so that you can roll back to a particular saved state of the database." https://www.c-sharpcorner.com/uploadfile/mahesh/rollback-commit-and-savepoints-in-ado-net/

using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.Connection = connection; SqlTransaction transaction = connection.BeginTransaction("Beginning"); command.Transaction = transaction; try { command.CommandText = "INSERT INTO Country (CountryName) VALUES ('Country1')"; command.ExecuteNonQuery(); transaction.Save("Inserted"); try { command.CommandText = "INSERT INTO City (CityName) VALUES ('City1')"; command.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback("Inserted"); } } catch (Exception ex) { transaction.Rollback("Beginning"); } }

For everyone arguing about the Rollback to Inserted. What's the purpose of the savepoint if you never rollback to it? I believe the question is just wrong here and the "second" variant is the actual correct question. So rollback("inserted") might indeed be true after all

As mentioned by Pepster the given solution is right

In my opion in the outermost catch block the transaction should be disposed because "beginning" is not a save point, it's the name of the transaction (https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.-ctor?view=netframework-4.8) and at that point no save point exists.

The last rollback also. If you name a transaction "inserted" you should rollback this transaction whether you roll it back in the first or the last catch block.

In the second itme, it should be Rollback("Inserted")