System.Data.SQLite: View Ticket

2012-01-25
18:17		• Closed ticket [b226147b37]: Designer deletes foreign key constraints plus 2 other changes artifact: 6dedf5cf1e user: mistachkin
18:17		When emitting SQL for foreign keys in the VS designer, be sure to take all returned rows into account. Fix for [b226147b37]. check-in: 38cd99987c user: mistachkin tags: trunk
13:37		More work on fixing ticket [b226147b37]. check-in: e67a436c40 user: mistachkin tags: VsDesignerFKey
2011-11-13
21:54		• Ticket [b226147b37] Designer deletes foreign key constraints status still Pending with 2 other changes artifact: 300fbbc89d user: mistachkin
2011-09-23
07:32		• Closed ticket [27507b5c65]: Visual Studio Designer plus 4 other changes artifact: 2185e962c8 user: mistachkin
2011-07-10
10:45		• Pending ticket [b226147b37]: Designer deletes foreign key constraints plus 1 other change artifact: 1292caf419 user: mistachkin
10:39		Support the ON UPDATE, ON DELETE, and MATCH clause information when generating schema metadata for foreign keys. Partial fix for [b226147b37]. VS designer changes are not yet tested. check-in: 9eb2e81611 user: mistachkin tags: trunk
09:02		• Ticket [b226147b37] Designer deletes foreign key constraints status still Open with 1 other change artifact: 93e817024c user: mistachkin
2011-07-07
04:27		• Ticket [b226147b37]: 2 changes artifact: 5e91cb31a8 user: mistachkin
2011-07-05
07:53		• Ticket [b226147b37]: 1 change artifact: a3c93f3dd5 user: mistachkin
2011-04-19
12:38		• Ticket [b226147b37]: 3 changes artifact: 998365e1ca user: shane
12:37		• Closed ticket [719070231d]: Constraint conflict resolution method not read into database designer plus 3 other changes artifact: d112ab8dee user: shane
2011-02-11
21:27		• New ticket [b226147b37] Designer deletes foreign key constraints. artifact: d93184dac4 user: anonymous

Ticket Hash:	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.

shane added on 2011-04-19 12:38:43 UTC:
See also [719070231d].

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

mistachkin added on 2011-07-10 09:02:47 UTC:
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.

mistachkin added on 2011-07-10 10:45:40 UTC:
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.

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

mistachkin added on 2012-01-25 18:17:47 UTC:
Fixed by check-in [38cd99987c] on trunk.