Error on Entity Developer: Model Creator Wizard

[OrozcoJ]

Good Morning;
Using the MySQL provider, I tried to create a Devart DM, after I connect to the MySQL database, I add it to the Model and I get an error. The error reads:
[Unknown Column 'DateTime_Precision' in 'field list'] and then another error with looking for column 'Routine_Type' in 'field list'. None of these columns exist in my database.

If I finish the wizard, the model is created but there are no properties on the entities or any relationships, just empty classes

This error is displayed in both VS11 and VS2008, i tried uninstalling and re-installing the LinqConnect and the MySQL providers but its not resolving the issue.

Thank you for your time

[MariiaI]

We couldn't reproduce this issue in our environment at the moment.
Please specify the following:
- the version and edition of your LinqConnect;
- the version of the MySQL server;
- the exact steps to reproduce this issue.

If possible, please send us the SQL scripts for creating database objects, that you are going to use in the model.

[OrozcoJ]

I get the same error, Im using the LinqConnect Express version 4.2(http://www.devart.com/linqconnect/download.html)
MySQL 6.0.3-alpha-community via TCP/IP

this is my Database and my table

Code: Select all

CREATE DATABASE `quiz` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `quiz`.`tblverifications`;

CREATE TABLE  `quiz`.`tblverifications` (
  `Codes` text,
  `Co_Name` text,
  `Co_Contact` text,
  `Contact_Email` text,
  `Contact_phone` text,
  `Qty` int(10) unsigned NOT NULL,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

Then all i do is try to create a data model using the wizard, nothing speciall really and get the error and the same results as the OP

[MariiaI]

Thank you for the additional information. We have reproduced this issue with the MySQL server 6.0.10-alpha-community (as well as with 6.0.3). However, this issue is not reproducible with the 4.0.21, 5.6.10 versions of MySQL server, etc.
We will investigate this behavior and inform you about the results as soon as any are available.

[MariiaI]

The bug related to the "Unknown column 'DATETIME_PRECISION' in 'field list'" error when creating model for MySQL 6.0.10-alpha-community is fixed.
New build of LinqConnect 4.2.247 is available for download now!
It can be downloaded from http://www.devart.com/linqconnect/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=31&t=27137.