System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: b226147b37f83badc20e9c0ab9b0235bd4035b4e
Title: Designer deletes foreign key constraints
Status: Closed Type: Code_Defect
Severity: Critical Priority: NextRelease
Subsystem: VsDesigner Resolution: Fixed
Last Modified: 2012-01-25 18:17:47
Version Found In: 1.0.66
Description:
If you modify a table in the designer and save it, these key words are ignored and removed.

 ON DELETE CASCADE ON UPDATE CASCADE

 

This is a showstopper bug. Sqlite supports these key words.

<hr /><i>shane added on 2011-04-19 12:38:43 UTC:</i><br />
See also [719070231d].

<hr /><i>mistachkin added on 2011-07-05 07:53:17 UTC:</i><br />
It appears the recognized keywords are contained in "System.Data.SQLite\SR.resx".

<hr /><i>mistachkin added on 2011-07-10 09:02:47 UTC:</i><br />
This issue is deeper than the list of recognized keywords.  The schema handling and the VS designer must be modified to support loading and saving the extra foreign key metadata for the ON UPDATE and ON DELETE clauses.


<hr /><i>mistachkin added on 2011-07-10 10:45:40 UTC:</i><br />
This may be at least partially fixed by the changes in [9eb2e81611]; however, the changes in [9eb2e81611] specific to the VS designer have not been tested because the installer tool has not been migrated yet.


<hr /><i>mistachkin added on 2011-11-13 21:54:10 UTC:</i><br />
Support for the compact framework will be ready for release 78 (i.e. the release after the upcoming one).


<hr /><i>mistachkin added on 2012-01-25 18:17:47 UTC:</i><br />
Fixed by check-in [38cd99987c] on trunk.