databasesqliteormdblinqdbmetal

DbMetal chokes on repeated foreign key references in SQLite - any ideas?


I've been struggling to get DbMetal to process my SQLite database. I finally isolated the problem. It won't allow a table to have two foreign key references to the same column.

For example, a SQLite database with these two tables will fail:

CREATE TABLE Person
(
    Id INTEGER PRIMARY KEY,
    Name TEXT NOT NULL
);

CREATE TABLE Match
(
    Id INTEGER PRIMARY KEY,
    WinnerPersonId INTEGER NOT NULL REFERENCES Person(Id),
    LoserPersonId INTEGER NOT NULL REFERENCES Person(Id)
);

I get this error:

DbMetal: Sequence contains more than one matching element

If I get rid of the second foreign key reference, no error occurs.

So, this works:

CREATE TABLE Match
(
    Id INTEGER PRIMARY KEY,
    WinnerPersonId INTEGER NOT NULL REFERENCES Person(Id),
    LoserPersonId INTEGER NOT NULL
);

But I really need both "person" columns to reference the Person table.

I submitted a bug report for this, but I could use a workaround in the meantime. Any ideas?


Solution

  • I just had the same problem and created a patch. I've also posted it at your bug report. For others, you can find the patch here: http://pastebin.com/VhNptMqp.