How I have this project, where in the database in a table modify something, then I want to update the visual study model.
But I get this error when I give update model from the database:
"An unexpected exception occurred when generating the model, see the output window for more details Exception message: 'EntityCommandExecutionException: Error executing the command definition See the internal exception for more details'. "
And in the exit window I get this:
The model can not be generated due to the following exception: 'System.Data.Entity.Core.EntityCommandExecutionException: Error executing the command definition. See the internal exception for details. --- > MySql.Data.MySqlClient.MySqlException: Illegal mix of collations for operation 'UNION'
in MySql.Data.MySqlClient.MySqlStream.ReadPacket ()
in MySql.Data.MySqlClient.NativeDriver.GetResult (Int32 & affectedRow, Int64 & insertedId)
in MySql.Data.MySqlClient.Driver.GetResult (Int32 statementId, Int32 & affectedRows, Int64 & insertedId)
in MySql.Data.MySqlClient.Driver.NextResult (Int32 statementId, Boolean force)
in MySql.Data.MySqlClient.MySqlDataReader.NextResult ()
in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (CommandBehavior behavior)
in MySql.Data.Entity.EFMySqlCommand.ExecuteDbDataReader (CommandBehavior behavior)
in System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior)
in System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__c (DbCommand t, DbCommandInterceptionContext% co_of% 1.Dispatch [TTarget, TInterceptionContext, TResult] (TTarget target, Func% co_of% 3 executing, Action% co_of% 2 orderByFunc, DataTable table, EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable 1 c)
en System.Data.Entity.Infrastructure.Interception.InternalDispatcher 1 filters)
in Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadStoreSchemaDetails (IList 3 operation, TInterceptionContext interceptionContext, Action 1 errors)
in Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModels (String storeModelNamespace, ModelBuilderSettings settings, List'1 errors)
in Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModel (ModelBuilderSettings settings, IVsUtils vsUtils, ModelBuilderEngineHostContext hostContext) '.
The loading of the metadata from the database took 00: 00: 03.7995425.
The generation of the model took 00: 00: 10.3886087.
It really does not let me do anything, if I delete tables and I have to add them, if I try to create a new model, I get the same thing