Handmade associations deleted when updating?

Handmade associations deleted when updating?

Postby hesseldehaan » Fri 20 Jan 2012 14:23


when I perform an Model update (right click -> Update model from database) all associations, that I have modified or added manually, disapear.

How can I perform an update / add table and still keep my associations?
Posts: 1
Joined: Fri 20 Jan 2012 14:15

Postby StanislavK » Fri 20 Jan 2012 17:03

The 'Update from Database' wizard drops the associations for which it couldn't find corresponding foreign keys in the database. You can, however, cancel dropping some of them at the 'Choose change action' step of the wizard: select the dependent table and clear the check box(es) at the 'ForeignKey (Dropped)' nodes.

Please tell us if this helps.
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Return to LinqConnect (LINQ to SQL support)