migratordotnet/Migrator.NET

Change IsolationLevel

Opened this issue · 0 comments

Currently the BeginTransaction method in TransformationProvider always uses IsolationLevel.ReadCommitted to begin the transaction. In MySQL 5.1.66 if you are using InnoDB tables and Statement based replication the isolation level must be either IsolationLevel.RepeatableRead or IsolationLevel.Serializable.

Could the TransformationProvider be updated so that the isolation level was configurable via a property? Or as a argument to the BeginTransaction method?