title: Table 'DBNAME.dbo.TableNAME' doesn't exist Entity Framework 6 with MySQL
body: <p>I am using Entity Framework 6.0.0 with MySql Server 5.6.17</p>
  
  <p>I have added MySql.Data.Entities through nuget and it installed Entity Framework 6.0.0 and MySql.Data 6.8.4</p>
  
  <p>Everything was setup perfectly and working fine with some of my Business Entities. it have automigration enabled(true).</p>
  
  <p>Later i have added some more entities and then it started giving error like </p>
  
  <pre><code>Table 'DBNAME.dbo.TABLENAME' doesn't exist Entity Framework 6
  </code></pre>
  
  <p>I have tried deleting whole database and recreate it again, but it didn't worked.</p>
  
  <p>I have tried updating Entity Framework to 6.1.2 and MySql.Data to 6.9.5 but it did not solved problem but gives some other error like  </p>
  
  <pre><code>Method not found: 'System.Data.Entity.Migrations.Builders.TableBuilder`1&lt;!0&gt; System.Data.Entity.Migrations.Builders.TableBuilder`1.Index(System.Linq.Expressions.Expression`1&lt;System.Func`2&lt;!0,System.Object&gt;&gt;, System.String, Boolean, Boolean, System.Object)'.
  </code></pre>
  
  <p>So i changed my EF and MySql.Data to previous version(EF 6.0.0 And MySql.Data 6.8.4)</p>
  
  <p>I found one more article <a href="http://bugs.mysql.com/bug.php?id=69649" rel="noreferrer">http://bugs.mysql.com/bug.php?id=69649</a> who has same error like me 
  so i modified my configuration method as below</p>
  
  <pre><code> public Configuration()
   {
              this.AutomaticMigrationsEnabled = true;
              SetSqlGenerator("MySql.Data.MySqlClient", new MySql.Data.Entity.MySqlMigrationSqlGenerator());
              CodeGenerator = new MySql.Data.Entity.MySqlMigrationCodeGenerator();
              AutomaticMigrationDataLossAllowed = true;  // or false in case data loss is not allowed.
   }
  </code></pre>
  
  <p>but it did not solved issue. i got same error again.</p>
  
  <p>My Sample Business Entity is as below.</p>
  
  <pre><code>public class User
  {
      [Key]
      public int UserID { get; set; }
      [Display(Name = "User Email")]
      [AllowHtml]
      public string UserEmail { get; set; }
      [MaxLength(100)]
      [Required(ErrorMessage = "Enter user password")]
      [Display(Name = "User Password")]
      [AllowHtml]
      public string UserPassword { get; set; }
      [MaxLength(50)]
      [Display(Name = "First Name")]
      [AllowHtml]
      public string FirstName { get; set; }
      [MaxLength(50)]
      [Display(Name = "Last Name")]
      [AllowHtml]
      public string LastName { get; set; }
      [Display(Name = "Profile Picture")]
      public string ProfilePicURL { get; set; }
      public string SaltKey { get; set; }
  }
  </code></pre>
  
  <p>Thanks for any help in advance</p>