title: EF6 MySQL changing all table prefixes
body: <p>I have a mysql db on a server where I've bought some space.
  Now I want to add a new mvc application to my website to try out some stuff, without buggering up my existing application.
  That puts me in a bit of a problem though as I only have one database available, I could just buy a new one, but I don't want to have to buy a new one every time I want to try stuff out.</p>
  
  <p>So I figured, why not just pre-fix all my tables with some unique value for that application, that way I can keep the stored data separate while still using the same db.
  That  took me on a journey across countless articles both here on stackoverflow and other places on the web.
  After about a day I stumbled upon this nugget</p>
  
  <pre><code>&lt;!-- language: c# --&gt;
  protected override void OnModelCreating(DbModelBuilder modelBuilder)
      {
          modelBuilder.Types().Configure(entity =&gt; entity.ToTable("pf_" + entity.ClrType.Name));
          base.OnModelCreating(modelBuilder);
      }
  </code></pre>
  
  <p>Which does exactly what I want, as long as you either use a mssql database, or you drop your mysql database and create a new one.
  However, the database I've been given is not an mssql database, and dropping it is not an option.</p>
  
  <p>When, with an existing mysql db, I try to run</p>
  
  <pre><code>update-database
  </code></pre>
  
  <p>I get the following error</p>
  
  <pre><code>Can't find file: '.\mytestdb\dbo@002etestitems.frm' (errno: 2 - No such file or directory)
  </code></pre>
  
  <p>where "mytestdb" is my local db that I'm testing on, "testitems" is the current/previous tablename, .frm is ofcourse the db format, and I have no idea what this "dbo@002e" is, I tried googling it to no avail.</p>
  
  <p>My stack trace can be found here.
  <a href="http://pastebin.com/yF2dGkm6" rel="nofollow">http://pastebin.com/yF2dGkm6</a></p>
  
  <p>Has anyone been in a similar situation, or has ideas as to how I can make it work? =)</p>