This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at firstname.lastname@example.org
I am receiving an error when migrating down on a MySQL database. The up migration works fine but going down I get an error "the database provider does not support deleting reference columns"
Before posting this I did a little investigation mixing in MSSQL and Entity Framework migrations When switching to an MSSQL database, the up and down methods worked fine with NHibernate When using MSSQL I can get Entity Framework migrations working When using MySQL I cannot get Entity Framework migrations working at all (including up method). I receive the error "No MigrationSqlGenerator found for provider 'MySql.Data.MySqlClient'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators."
Looking up the Entity Framework error, it seems to be related to mixing wrong versions of the MySQL data provider, Visual Studio, Entity Framework, and/or MySQL. I suspect this may be the same problem with the NHibernate Designer migrations and MySQL.
I'm going to try some different versions to see if I can figure it out and will let anybody know if it works, but if anybody knows exactly which versions are supported or anything else I need to do I'd appreciate the help before I just start mixing the tons of different versions.
Here's what I'm using:
Thanks for any help!