Mysql - Visual Web Developer - Entity Framework

Question

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:

I have referenced MySql.Data, MySql.Web and MySql.Data.Entity in my project, but to no avail.
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>

I have changed the previous connection string into a normal connection string like so:
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?

Devart · Accepted Answer · 2011-03-31 13:39:36Z

4

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.

answered Mar 31, 2011 at 13:39

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steven Lemmens Over a year ago

Thanks for the help. I ended up using edmgen2 to generate my Model and this works fine. It kind of sucks that I can't update the model from my Visual Studio environment, but oh well, that's the limitations of the Express versions, I guess.

Collectives™ on Stack Overflow

Mysql - Visual Web Developer - Entity Framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related