Updated code in Migrator to update database using transactions.

Implemented the same mechanism as EF6 for handling sql statements with SuppressTransaction == true.