System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: d5167367fe122681908d84e7ce6d0b07b177c2e5
Title: Designer from Database : OnDelete property value missing
Status: Deferred Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: VsDesigner Resolution: Under_Review
Last Modified: 2015-02-05 20:25:37
Version Found In: 1.0.94.0 (3.8.6)
User Comments:
anonymous added on 2015-02-05 10:47:42:
Using Visual Studio 2013, when creating an EF Designer from a sqlite DB file,
the relation constraints do not have the correct OnDelete property value.

End1 OnDelete is set to None
End2 OnDelete is set to None

However the database file correctly has the Cascade value:
FOREIGN KEY(`node_id`) REFERENCES tbl_mast_nodes ( node_id ) ON DELETE CASCADE ON UPDATE CASCADE

Additional note:
I don't see the OnUpdate property.

mistachkin added on 2015-02-05 20:25:25:
This root cause of this appears to be that the ForeignKeyEditor constructor,
when called from the TableDesignerDoc.Exec method, creates ForeignKey objects
without passing them valid DataRow objects to populate their property values
from.