MySQL Bugs: #58278: ADO.Net Entity Framework connection problem

Bug #58278	ADO.Net Entity Framework connection problem
Submitted:	18 Nov 2010 9:08	Modified:	7 Jan 2011 15:58
Reporter:	Benjamin Kahler	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.3.5	OS:	Windows
Assigned to:	Reggie Burnett	CPU Architecture:	Any
Tags:	No Functionallity in Visual Studio

Description:
I tried since two days to work with ADO.Net Entity Data Models and a MySQL Database(Engine is InnoDB).

The Documentation said, i can access the Database by Generating a new "ADO.Net Entity Data Model" in Visual Studio and create a new Database Connection.

So in the Server Explorer, i created this Connection. But in the Entity Data Model i'm not able to choose wether a MySQL Connection nor a ODBC Connection.

So i think the Connector doesn't provide the Use of Entity Data Models. This is very annoying, because the Documentation promised it to my Boss and he wants to get this Feature done.

What can i do for Fixing it?

Greetings, Benni

PS: Sorry for my English i think it isn't very good...

How to repeat:
Open Visual Studio 2008 or 2010 and create a new Serverconnection to the MySQL Server.

Open a new Project in VisualStudio 2008 or 2010, Add a new Component and choose a new ADO.Net Entity Data Modell

Choose "Generate from existing Source". The Dropdown Box for new Connection will appear without any Content and if you click on new Connection there are only Microsoft SQL Server Connections. The Connections from the Net/Connector doesn't apppear there.

Hi Benjamin and thanks for your report.

Detailed tutorial can be found at http://dev.mysql.com/doc/refman/5.5/en/connector-net-tutorials-entity-framework-winform-da.... Please follow the steps described there and see if it helps.

That are the Steps i've Done.

If I click on "New Connection" in Step 3 a Window appears where i should choose wich DataProvider I want to use. But there are only the Standard Microsoft DataProviders (MS SQL Server etc.) and nothing like "MySQL". I've installed the Connector and if I Connect to the Server via Server Explorer, there are the MySQL Dataproviders.

But i can't use the Databaseconnection of the Serverexplorer for the ADO.NET Entity, because the dropdownbox is empty.

Benjamin, what's wrong with using existing connection made as described in http://dev.mysql.com/doc/refman/5.5/en/connector-net-visual-studio-making-a-connection.htm...?

If that does not work either then connector might have not been installed properly in your environment.

Hi Tonci,

i've tried this even, the Connection but the Connection doesn't appear when I want to create a new ADO.Net Entity Data Model.

I've installed, and deinstalled the Connector above 3 or 4 times (PS: I use Win7 as O/S). After that doesn't seemed to work, I've downloaded the "noinstall"-package of the Net/Connector and copied the DLL's, installed them in the GAC and registered the MySQL.Data.dll in machine.config, but that either hasn't worked.

I've now deinstalled everything and reinstalled. And it doesn't work...

Is it possible, that i can only connect to Servers in my Local Network? Because the Server is virtualized Machine in a Data Center with a public IP-Adress?

Benjamin, verified just as described on W2K8R2 x64 with VS2005 & 2008 Pro using c/NET 6.3.5. Following tutorial from http://dev.mysql.com/doc/refman/5.5/en/connector-net-tutorials-entity-framework-winform-da... shows no c/NET connections/driver even though plenty of them in server explorer.

Reggie?

Hello, I have the same problem but only on vs2008, with vs2010 it works fine and I can select mysql provider from the data source list.

I have installed connector version 6.3.4 and it works, but version 6.3.5 doesn't work well on vs2008.

I also have had exactly the same problem as described above, but I went with Juan and installed 6.3.4 and it works perfectly

So, 6.3.5 only works under VS 2010.

I've got now VS 2010 and Re-Installed the 6.3.5 Connector and now it works fine.

That's right, connector 6.3.5 seems to work fine only with VS2010, with VS2008 only works with server explorer but when you are adding a new connection to your project, mysql doesn't appear in the options.

This was caused by a build problem with 6.3.5.  We have corrected that with 6.3.6.

And has the new version 6.3.6 been released??

An entry has been added to the 6.3.6 changelog:

When attempting to create an ADO.NET Entity Data Model, MySQL connections were not available.

Unfortunately, I cannot confirm the solution.

The issue just occured again with version 6.3.6.

I downloaded the Mysql.NET connector today from http://www.mysql.com/downloads/connector/net/ and installed it on a new Windows Server 2008 R2 / Visual Studio 2008 SP1 system.

The effect is the same, I can see the Connector within the server manager dialoges but not within the entity data model wizard.

Can anybody confirm this effect with version 3.6.3?

Thanks in advance

Andre

sorry, I meant version 6.3.6 :)

Hello, I have connector v6.3.6 installed and I don't have this issue anymore.

The only problem that gives me this version is that when I open the about box dialog on VS, it throws the error that the connector is not correctly loaded or something like that, but it's not an important one.

Greetings.

Thanks Juan, you're right.

I found an explanation for my strange behavior. There was an older version of the MySql.Net Connector already installed on my system which aborted the regular setup routine.

Sorry for the wrong bug report.

Andre