All geek questions in one place

Mysql - Visual Web Developer - Entity Framework

I had the following problem.

I have Visual Web Developer 2010 Express, and I'm trying to get it to work with the Entity Framework and the MySQL database.

I have the .NET Connector installed for MySql, but it does not seem to integrate with Web Developer, as in Visual Studio 2010 (professional version). The Entity Data ADO.NET Data Model Wizard asks me for data to connect to the database, but I can’t select the MySql driver, so I can’t create a connection, so, in short, I can’t continue.

Things I've tried so far:

1) I referenced MySql.Data, MySql.Web and MySql.Data.Entity in my project, but to no avail.

2) I manually created a connection string in my Web.config as follows:

<connectionStrings> <add name="modelEntities" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=MySql.Data.MySqlClient; provider connection string='server=localhost;User Id=simply; database=simply;password=simply'" providerName="System.Data.EntityClient"/ </connectionStrings>

At the same time, I added the following code:

 <system.data> <DbProviderFactories> <clear /> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/> </DbProviderFactories> </system.data>

3) I changed the previous connection string to a regular connection string as follows:

 <add name="connection" connectionString="server=localhost;database=simply;uid=simply;password=simply" providerName="System.Data.EntityClient"/>

4) I added the following code to my machine.config file (and rebooted the computer):

 <DbProviderFactories> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /> </DbProviderFactories>

All this has not yet helped. Can someone point me in the right direction and explain to me how I should run my Entity Framework with MySql?

Thanks so much for any help you guys can give me.

+4
source share
1 answer

This is a designed behavior - VS does not allow third-party extensions in Express versions .
We have provided some tips here on our forum.
You can try to achieve the same results using edmgen .

+4
source

Source: https://habr.com/ru/post/1345949/

More articles:


All Articles