System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 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