“The given key was not present in the dictionary”, create data model mysql visual studio 2017

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


“The given key was not present in the dictionary”, create data model mysql visual studio 2017



I have hours looking for how to solve the error and I can not find it, and uninstall and install mysql several times and I can not solve it, thanks for your help



visual studio 2017 comunity
mysql 8.0.12 (installed with mysql installer)
conector net 8.0.12 (installed with mysql installer)
mysql.data.entity 6.10.7 (installed with nuget)
mysql.data 6.9.12 (installed with nuget)
NET framework 4.5



the test conection is success
I only have one table, is this
CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE mydb; CREATE TABLE negocios ( idNegocio int(11) NOT NULL, nombre varchar(45) DEFAULT NULL, calle varchar(45) DEFAULT NULL, activo int(11) DEFAULT NULL, colonia varchar(45) DEFAULT NULL, municipio varchar(45) DEFAULT NULL, numero int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE mydb; CREATE TABLE negocios ( idNegocio int(11) NOT NULL, nombre varchar(45) DEFAULT NULL, calle varchar(45) DEFAULT NULL, activo int(11) DEFAULT NULL, colonia varchar(45) DEFAULT NULL, municipio varchar(45) DEFAULT NULL, numero int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



the error “The given key was not present in the dictionary”, after of success conection for create model





Probably an unsupported data type in a database column.
– Gert Arnold
19 mins ago









By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Visual Studio Code: How to configure includePath for better IntelliSense results

Spring cloud config client Could not locate PropertySource

Regex - How to capture all iterations of a repeating pattern?