DbLinq DbMetal -添加外键时“给定键不在字典中”

Question

这是我的初始SQLite数据库

CREATE TABLE [Categories] (
  [ParentId] INT, 
  [Name] VARCHAR(100));

CREATE TABLE [Fees] (
  [CategoryId] INT, 
  [Name] VARCHAR(100), 
  [Value] VARCHAR(50), 
  [Info] VARCHAR(200));

CREATE TABLE [Markups] (
  [CategoryId] INT, 
  [UpTo] MONEY, 
  [Value] VARCHAR(50), 
  [Info] VARCHAR(200));

如果我运行DbMetal /provider:Sqlite /conn "Data Source=bms4.db3" /dbml:Model.dbml，它将成功创建dbml文件。

但是如果我添加一个外键，这样

CREATE TABLE [Fees] (
  [CategoryId] INT CONSTRAINT [fk_fees_categories] REFERENCES [Categories]([rowid]), 
  [Name] VARCHAR(100), 
  [Value] VARCHAR(50), 
  [Info] VARCHAR(200));

运行相同的命令

DbMetal /provider:Sqlite /conn "Data Source=bms4.db3" /dbml:Model.dbml

将显示此错误：

>>> Reading schema from SQLite database
DbMetal: The given key was not present in the dictionary.

如何在DBML中引入外键关系？

Answer 1

根据约束中的唯一键检查外键。您尚未声明主键或唯一键，因此需要从声明开始(最好确保每个表都有一个主键)