mysqlasp.net-mvcentity-framework

Mysql - Visual Web Developer - Entity Framework

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

I have the .NET Connector for MySql installed, but it doesn't seem to integrate with Web Developer, as it does with Visual Studio 2010 (professional edition). The wizard for creating the ADO.NET Entity Data Model asks me for the data to connect to the database, but I can't choose 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 have referenced MySql.Data, MySql.Web and MySql.Data.Entity in my project, but to no avail.

  2. I have manually created a connection string in my Web.config like so:

At the same time, I have also added 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>

  1. I have changed the previous connection string into a normal connection string like so:

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

All of this has been to no avail so far. Can anyone point me in the right direction and explain to me how I'm supposed to get my Entity Framework with MySql up and running?

Solution

  • This is the designed behaviour - VS does not allow 3rd party extensibility in Express versions.
    We have provided some piece of advice here at our forum.
    You can try to achieve the same results using edmgen as well.