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.
|