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!
i can't install mysql connector/net 6.3.2 in windows 7 ultimate
ReplyDeleterolling 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
Helo,
ReplyDeleteI'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
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)
ReplyDeletetemplate. I get Line 0, Column 0 expression evaluates to null.
Is there anything I can do about this at this time?
Do you expect that this connector will work with Amazon's MySql interface, or is there another layer that is needed?
ReplyDeleteNote to my previous post, I am using the VS 2010 and am using the entity framework.
This is fixed in 6.3.3 beta 2 which should be available for download tomorrow (7/26)
ReplyDeleteI think this is fixed in the 6.3.3 release that should be available tomorrow (7/26)
ReplyDeleteI test it with VS 2010 so please try the 6.3.3 build that should be available tomorrow (7/26)
ReplyDeleteIt should work. Please let me know if it doesn't.
ReplyDeleteI couldn't find the second beta. Where can I find it after its released as 6.3.3 beta 2
ReplyDeleteI 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.
ReplyDeleteI 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.
ReplyDeleteI 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:
ReplyDeleteCREATE 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.
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
ReplyDeleteWhat 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?
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.
ReplyDeleteI 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
ReplyDeleteI 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
ReplyDeleteand 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.
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.
ReplyDeleteYes, please file a bug report at bugs.mysql.com
ReplyDeleteI have installed the latest version of VS2010, and the MySql Connector .NET 6.3.5...
ReplyDeleteWhenever 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.