Error on Entity Developer: Model Creator Wizard

Error on Entity Developer: Model Creator Wizard

Postby OrozcoJ » Thu 12 Jul 2012 17:19

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
OrozcoJ
 
Posts: 2
Joined: Thu 12 Jul 2012 16:59

Re: Error on Entity Developer: Model Creator Wizard

Postby MariiaI » Fri 13 Jul 2012 11:52

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Error on Entity Developer: Model Creator Wizard

Postby OrozcoJ » Thu 25 Apr 2013 23:37

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
OrozcoJ
 
Posts: 2
Joined: Thu 12 Jul 2012 16:59

Re: Error on Entity Developer: Model Creator Wizard

Postby MariiaI » Fri 26 Apr 2013 12:08

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
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Error on Entity Developer: Model Creator Wizard

Postby MariiaI » Mon 20 May 2013 05:30

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)