MySQL Connector/Net 6.3.2 beta has been released
- Visual Studio 2010 RTM support
- New sql editor. Create a new file with a .mysql extension to see it in action
-
-
#2 written by reggie 1 year ago
-
-
#3 written by willyam 1 year ago
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
-
#4 written by reggie 1 year ago
-
-
#5 written by GMX 1 year ago
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?
-
#6 written by reggie 1 year ago
-
#7 written by GMX 1 year ago
-
#8 written by GMX 1 year ago
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.
-
#9 written by GMX 1 year ago
-
-
-
#10 written by GMX 1 year ago
-
#12 written by GMX 1 year ago
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 9The line `Address1` nvarchar(max) NOT NULL, has a red
X by it and max is highlighted in red. -
#13 written by GMX 1 year ago
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?
-
#14 written by GMX 1 year ago
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.
-
#15 written by GMX 1 year ago
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
-
#17 written by GMX 1 year ago
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. -
#18 written by GMX 1 year ago
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.
-
#19 written by Festus 1 year ago
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.
-
Comments are closed
- Comment Feed for this Post
- Battery testing my mobile phones
- How Microsoft can fix WP7 in 2012
- You always have to consider the source
- Do you really need to pay for a phone again?
- MySQL Connector/Net 6.4.4 has been released
- Forum for MySQL Installer
- Welcome to the world, MySQL Installer for Windows!
- MySQL Connector/Net 6.4.3 GA has been released
- MySQL Connector/Net 6.2.5 GA has been released (legacy)
- MySQL Connector/Net 6.1.6 (legacy update) has been released
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