title: Is it possible with Entity-Framework to apply all pending migrations TRANSACTIONALLY and rollback if any errors?
body: <p>Let's say I have migrations</p>
  
  <pre><code>Initial.cs
  foo.cs
  bar.cs
  baz.cs
  </code></pre>
  
  <p>and my database is current "in sync" with applying</p>
  
  <pre><code>Initial.cs
  foo.cs
  </code></pre>
  
  <p>and what I want to do is the equivalent of</p>
  
  <pre><code>Try applying bar.cs and then baz.cs, all in a transaction. If it fails, roll back.
  </code></pre>
  
  <p>Is that possible using <code>Update-Database</code> or <code>migrate.exe</code> with parameters or does it request special Powershell script or even custom C# logic?</p>