|Title:||Designer from Database : OnDelete property value missing|
|Last Modified:||2015-02-05 20:25:37|
|Version Found In:||188.8.131.52 (3.8.6)|
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.