Tuesday, June 1, 2010

MySQL Connector/Net 6.3.2 beta has been released

Sorry for this not getting out sooner.  Connector/Net 6.3.2 was released several days ago but somehow the release announcement was never made.


MySQL Connector/Net 6.3.2, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. This

release should not be used in a production environment.  It is now available in source and binary form from

[http://dev.mysql.com/downloads/connector/net/6.3.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later

or choose another download site.)


The new features or changes in this release are:



  • Visual Studio 2010 RTM support

  • New sql editor.  Create a new file with a .mysql extension to see it in action



What we know may be broken

Documentation is not updated yet and is not integrated into VS 2010


Please let us know what else we broke and how we can make it better!

19 comments:

  1. i can't install mysql connector/net 6.3.2 in windows 7 ultimate
    rolling back action while installing
    it says 'MySQL Connecter Net 6.3.2 Setup Wizard ended preamturely because of an error. Your system has not been modified. .....'
    Please advise
    Thank You

    ReplyDelete
  2. Helo,

    I've installed mysql connector/net 6.3.2 but i still can't run it with VS2010. When i try to add connection to database it send an error message : " could not load type: System.runtime.verssionning.TargetFrameworkAttribut from assembly 'mscorlib.

    I would be greatfull if you have an idea about this problem

    ReplyDelete
  3. I just loaded 6.3.2 and MySql 5.5 Both are the Beta versions. I am able to access an existing MySql database, but I haven't been able to do a model first development, as I would like to. Errors seem to occur when I use the SSDLToMySQL.tt (VS)
    template. I get Line 0, Column 0 expression evaluates to null.

    Is there anything I can do about this at this time?

    ReplyDelete
  4. Do you expect that this connector will work with Amazon's MySql interface, or is there another layer that is needed?

    Note to my previous post, I am using the VS 2010 and am using the entity framework.

    ReplyDelete
  5. This is fixed in 6.3.3 beta 2 which should be available for download tomorrow (7/26)

    ReplyDelete
  6. I think this is fixed in the 6.3.3 release that should be available tomorrow (7/26)

    ReplyDelete
  7. I test it with VS 2010 so please try the 6.3.3 build that should be available tomorrow (7/26)

    ReplyDelete
  8. It should work. Please let me know if it doesn't.

    ReplyDelete
  9. I couldn't find the second beta. Where can I find it after its released as 6.3.3 beta 2

    ReplyDelete
  10. I loaded something that looked like the 6.3.3 beta 2. It does generate a script. When i tried to execute it in VS2010, VS asked to open Sql Express. Then I tried to execute it in MySql Workbench. I could load the sql, but it wouldn't execute with the complaint that there was no server selected. Am I doing something wrong, or is there still a problem. How should I be executing the script to modify the database to work with my model? If I'm doing something wrong, I'd really appreciate some instructions on how to perform this task.

    ReplyDelete
  11. I was able execute the script that VS 2010 generated using 6.3.3 beta 2. Then I was able to delete all of the items in the edmx file and create the model form the database. That completes the cycle, thanks.

    ReplyDelete
  12. I am using Visual Studio 2010 and your Connect/Net 6.3.3 Beta 2. Specifically I have an edmx file that I generated from a Sql Server Database that I want to migrate to MySql. I generated an edmx.sql file using Generate Database from Model. I used the template for MySQL. Then used MySql Workbench to execute a MySql Database, there was a syntax error part way through as follows:

    CREATE TABLE `Addresses` (
    `AddressID` bigint AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `Address1` nvarchar(max) NOT NULL,
    `Address2` nvarchar(max) NOT NULL,
    `Address3` nvarchar(max) NOT NULL,
    `City` nvarchar(max) NOT NULL,
    `State` nvarchar(max) NOT NULL,
    `PostCode` nvarchar(max) NOT NULL,
    `Role` nvarchar(max) NOT NULL,
    `Use` nvarchar(max) NOT NULL,
    `Note` nvarchar(max) NOT NULL
    );
    The error message was You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max) NOT NULL,
    `Address2` nvarchar(max) NOT NULL,
    `Address3` nvarchar(' at line 9

    The line `Address1` nvarchar(max) NOT NULL, has a red
    X by it and max is highlighted in red.

    ReplyDelete
  13. In looking at the projects that are generated by Visual Studio 2010 for MVC2, I notice that a major component is the AccountModels.cs which is generated automatically and uses the connection string in web.config

    What is the strategy for using MySql for this database. Note that there are several providers identified in the web.config that use this connection. Does Connect/Net support this functionality or does it need to provide any support?

    ReplyDelete
  14. I am using Visual Studio 2010 and MVC2. I created a MySql database with a sql script in MySql Workbench. I have Connector/Net 6.3.3 beta 2. I added a new item to create an ADO.Net Entity Model from the for the MySql database. The resulting model had lower case names for all of the tables in the diagram. I looked an saw that this probably comes from the fact that the Table names in the MySql database are also lower case. Note from my previous comments I am generating with the MySql tt file from Visual studio all use upper case names also. Somewhere in the process, the table names which begin with an upper case first letter are going to all lower case names. This is more a pain in the neck than anything else since I have to modify the names in the edmx diagram in oder for compatability with existing code. However, I am reporting this as a problem because it might make it hard for some people to migrate from Sql server to MySql. I'd think that is one of your goals.

    ReplyDelete
  15. I have a couple of additional problems that have shown up in using the 6.3.3 beta 2. Is there somewhere I can send detailed information that is too big to post here. I really want to help you identify problems so that we get the best tool we can. What I am doing is trying to move a project from Sql Server to MySql using the released VS 2010

    ReplyDelete
  16. I am using the 6.3.3 beta 2 and VS2010. When I make an ADO.Net Entity Framework edmx file the fields in the edmx files are not always in the same order as the corresponding MySql Table. The MySql database was generated from a Sql Server Express database by creating a database from model using the MySql template. The MySql Database was loaded by executing the sql in MySql Workbench. The order of the fields in the tables in that database is the same as the order in the edmx files. When I create a connection to that database
    and add the entity framework model to another project, the fields are not in the same order. This wouldn't make a lot of difference, except that the parameters of the Creat... function mirror the order in the edmx file, and don't match the order in the parmeters in my preexisting application code that was generated against the original SqlServer database. This means that it is not possible to maintain a single application code base for the two projects, and it makes the migration to MySql much more difficult.

    ReplyDelete
  17. When I went through the conversion process described in many of the posts above, most of the navigation properties retained their original names. However, navigation properties in one table referenced the same table, though different records. These properties did not retain their same names. This again makes migration a pain in the neck. The navigation properties are present, but they have different names. As before this is a big problem for people trying to migrate from sql server to MySql. Since navigation properties between tables seem to be ok, this may not be as common a problem as the other migration problems I have reported above.

    ReplyDelete
  18. Yes, please file a bug report at bugs.mysql.com

    ReplyDelete
  19. I have installed the latest version of VS2010, and the MySql Connector .NET 6.3.5...

    Whenever I try to configure a MySql datasource from the Server Explorer, I am able to select MySql.

    When the Add Connection shows up, it immediately disappears without any error messages, the moment I try to type anything. First Keystrok and its gone.

    Any Ideas whats going on? I cant even enter the server name..

    Please help.

    Also whats the best suggestion for VS, EDM and eventually compiling to Mono?

    Thanks.

    ReplyDelete