Why is Code First from MySQL Database not creating model, connectionString?

Kurt Wagner Published at Dev

Kurt Wagner

So I have the following:

VS2015 Enterprise 14.0.23107.0 D14REL
MySQL for VisualStudio 1.2.4
Connector/NET 6.9.7

Nuget:

EntityFramework 6.1.3
MySql.Data 6.9.7
MySql.Data.Entities 6.8.3
MySql.Web 6.9.7

And the following in Web.config:

  <entityFramework>
    <defaultConnectionFactory type="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6" />
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
    </providers>
  </entityFramework>

Within Server Explorer I have a valid connection to a remote MySql Server instance and read/write tables, etc. However, when I try to add an ADO.NET entity and select 'Code first from database', hit next, select the connection, mark "Yes, include the sensitive data in the connection string" and leave the "Save connection settings Web.Config as:" checked as well as the name textfield and then hit next, Visual Studio seems to think a bit, shows the picture below real quick, and then the wizard closes. However, there are no models created nor is there a connectionString created in Web.config. Why is this happening and how do I fix it?

Barkermn01

I have had this problem and was never able to fix it, I think VS just can't manage the Mysql Database inside its server explorer for datasets/binding.

Even in WPF, I had to manually build Dataset objects for WPF binding - it was a pain in the arse. If you can, stick with MSSQL or learn how to program MySQL, in C#/VB.NET it's not nice.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-21

Comments

0 comments

From Dev

Related Related

Article

Why is Code First from MySQL Database not creating model, connectionString?

Why is Code First from MySQL Database not creating model, connectionString?

Code first database not being created from model

Why is it called 'Code First' from database in EF

Creating a database with MySQL Workbench from existing schema/model

Why database first classes differ from my code first classes

auto update code first from database model, is it possible?

Why is Hibernate not creating database for MySQL?

Creating database through code first EF

creating a database in mysql from java

creating a database in mysql from java

How to add additional tables to an existing code first from database EF model?

'Code First From Database' Template not showing in Visual Studio Entity Data Model Wizard

Entity Framework 6.1.3 initialize existing, but empty database from code-first model

Code-first vs Model/Database-first

Creating Pyramid/SQLAlchemy models from MySQL database

Creating polylines from mysql database in google maps

Creating a list using data from MySQL database

Entity Framework Code First Migration in MySql DataBase

Entity Framework 5 code-first not creating database

Entity Framework: Help Creating Database using Code first Approach

Entity Framework: Help Creating Database using Code first Approach

Creating an ADO.Net Entity Data Model with MySQL database?

Creating database model with Mongoose

Why Is My C# Code Only Displaying The First Row from my Database?

Code First or Model First

Code First or Model First

ASP.NET MVC creating Model from Database (Postgres)

Switching from entity framework model first to code first

Code First not creating tables

Entity Framework run-time ConnectionString when using Database First