New Version Updating Model

New Version Updating Model

Postby Zero-G. » Mon 23 May 2011 15:06

Hey
I have downloaded the latest product Version of v6.3 for mySQL

I have two problems with the new version:
1) The mapping of the fields are going confused.
I have tried to update the model by syncronisation with the database. There are some confusing Source fields. Some of the Source fields get added the value 1. Like: Field name in mySQL = ID In the ModelDesigner, The Source is ID1
2) I have foreign keys defined between char(4) fields. - In the mySQL Server everything works fine, but the Model Designer does not know this, so I have to define them after an automatic update by hand again (30 tables, don't make this work funny...)

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby StanislavK » Mon 23 May 2011 17:01

Could you please describe the problems in more details? For example, please specify the following:
- whether you've run the 'Update Database from Model' or 'Update Model from Database' wizard;
- the fields of the entity with the 'ID1' storage property, and the columns of the corresponding table;
- what associations were created for the char(4) foreign keys.

If possible, please specify the scripts needed to create the database objects with which these problems occurred.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to LinqConnect (LINQ to SQL support)