Ticket Hash: | 857e8a8fe7f00784fc679a09baf54f3f4b2c4017 | |||
Title: | Foreign key with multiple columns | |||
Status: | Deferred | Type: | Feature_Request | |
Severity: | Important | Priority: | Medium | |
Subsystem: | VsDesigner | Resolution: | Open | |
Last Modified: | 2014-12-05 22:19:06 | |||
Version Found In: | 1.0.93 | |||
User Comments: | ||||
anonymous added on 2014-07-31 23:02:51:
(text/x-fossil-plain)
Using VS 2012, I tried Get Model from Database to generate from an existing database, there are issues with my database model where there a foreign key referencing multiple columns. In the edmx file I found this: <!--Errors Found During Generation: warning 6035: The relationship 'FK_*****_0_0' has columns that are not part of the key of the table on the primary side of the relationship. The relationship was excluded. <Association Name="FK_*****_0_0" />--> <!--Errors Found During Generation: warning 6035: The relationship 'FK_*****_0_1' has columns that are not part of the key of the table on the primary side of the relationship. The relationship was excluded. <Association Name="FK_*****_0_1" />--> Table: CREATE TABLE IF NOT EXISTS `*****` ( `a` int(11) NOT NULL, `b` int(11) NOT NULL, `c` int(11) NOT NULL, `d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `e` varchar(5) NOT NULL, ... PRIMARY KEY (`a`,`b`,`c`), FOREIGN KEY (`a`,`b`) REFERENCES `***********` (`a`, `b`) ON DELETE CASCADE ON UPDATE CASCADE ); anonymous added on 2014-10-31 17:09:03: (text/x-fossil-plain) maybe related to http://system.data.sqlite.org/index.html/tktview?name=1ec39fe4bd |