title: Change primary key when using EF migrations in Sql Azure
body: <p>I have changed the primary key in my entity. When I try and run the migration on SQl Azure it fails with "Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again."</p>
  
  <pre><code> public override void Up()
   {
      DropPrimaryKey("User", new[] { "Id" });
      AddPrimaryKey("User", "Username");
   }
  </code></pre>
  
  <p>How can I solve this? The only thing I can think of is to create my own ChangePrimaryKey method that somehow silently creates a temporary table with the correct primary key, copies the data over, then replaces the original.</p>