SubSonic无法识别SQLite外键(SubSonic not recognizing SQLite foreign keys)

 我正在使用SubSonic 3.0.0.3，我似乎无法获得ActiveRecord .tt文件来识别和生成我的SQLite数据库中的外键和关系的代码。 
 
 我认为它可以很好地生成其他所有内容，但在查看其他在线代码片段之后，看起来应该有更多生成的代码，而不仅仅是ActiveRecord.cs单个类和每个表的Structs.cs 。 在Structs.cs里面， IsForeignKey对于每一列都是false的，甚至是我为其定义的外键。 此外，每个Foreign Keys区域在每个生成的ActiveRecord类中都是空的。 
 
 我在我的项目中使用的VS2008引用了SubSonic 3.0.0.3，System.Data.SQLite 1.0.66.0和System.Data.SQLite.Linq 2.0.38.0。 我使用SQLite Expert Personal 3.1.0.2076创建了数据库。 我做了一些虚拟表来尝试测试SubSonic如何处理一个：很多很多：许多关系。 这是我的小型数据库的DDL SQLite Expert吐出： 
 
CREATE TABLE [Person] (
[PersonID] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,
[PersonName] TEXT  NOT NULL,
[PersonAge] INT  NOT NULL
);

CREATE TABLE [Group] (
[GroupID] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,
[GroupName] TEXT  NOT NULL,
[GroupDescription] TEXT  NOT NULL
);

CREATE TABLE [Dog] (
  [DogID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
  [PersonID] INT NOT NULL CONSTRAINT [DogPersonFK] REFERENCES [Person]([PersonID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [DogName] TEXT NOT NULL);

CREATE TABLE [GroupPersons] (
  [GroupID] INTEGER NOT NULL CONSTRAINT [GroupPersonToGroupFK] REFERENCES [Group]([GroupID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [PersonID] INTEGER NOT NULL CONSTRAINT [GroupPersonToPersonFK] REFERENCES [Person]([PersonID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  CONSTRAINT [sqlite_autoindex_GroupPersons_1] PRIMARY KEY ([GroupID], [PersonID]));
 
 我知道外键已启用并在数据库中工作 - SQLite Expert说他们正在使用，当我在一个地方更改数据时，比如Person的PersonID，它确实改变了Dog和GroupPersons表中的PersonID。 我已经尝试将数据库重新添加到项目中，“运行自定义工具”以使.tt文件再次执行，甚至删除它们并将其添加回来。 我可以创建一个简单的项目来执行简单的查询和插入，但是我现在尝试更改单个Person，Dog或Group的主键和x.Save（），但是System.Data.SQLite引发了异常这三个， SQLite error near "WHERE":syntax error.说SQLite error near "WHERE":syntax error. 在Save（）。 
 
 对于我接下来应该尝试做什么的任何建议？ 

I'm using SubSonic 3.0.0.3 and I can't seem to get the ActiveRecord .tt files to recognize and generate code for the foreign keys and relationships in my SQLite database. 
 
I think it generates everything else just fine, but after looking at other snippets online it looks like there should be more generated code than just single classes in ActiveRecord.cs and Structs.cs for each of my tables. Looking inside Structs.cs, IsForeignKey is always false for every column, even the ones I have a foreign key defined for. Additionally, each Foreign Keys region is empty within each generated ActiveRecord class.
 
I'm using VS2008 with references to SubSonic 3.0.0.3, System.Data.SQLite 1.0.66.0, and System.Data.SQLite.Linq 2.0.38.0 in my project. I created the database using SQLite Expert Personal 3.1.0.2076. I made some dummy tables to try to test out how SubSonic handles one:many and many:many relationships. Here's the DDL SQLite Expert spits out for my small database:
 
CREATE TABLE [Person] (
[PersonID] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,
[PersonName] TEXT  NOT NULL,
[PersonAge] INT  NOT NULL
);

CREATE TABLE [Group] (
[GroupID] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,
[GroupName] TEXT  NOT NULL,
[GroupDescription] TEXT  NOT NULL
);

CREATE TABLE [Dog] (
  [DogID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
  [PersonID] INT NOT NULL CONSTRAINT [DogPersonFK] REFERENCES [Person]([PersonID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [DogName] TEXT NOT NULL);

CREATE TABLE [GroupPersons] (
  [GroupID] INTEGER NOT NULL CONSTRAINT [GroupPersonToGroupFK] REFERENCES [Group]([GroupID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [PersonID] INTEGER NOT NULL CONSTRAINT [GroupPersonToPersonFK] REFERENCES [Person]([PersonID]) ON DELETE CASCADE ON UPDATE CASCADE, 
  CONSTRAINT [sqlite_autoindex_GroupPersons_1] PRIMARY KEY ([GroupID], [PersonID]));
 
I know foreign keys are enabled and work in the database - SQLite Expert says they're on and when I change data in one place, like Person's PersonID, it does indeed change that PersonID in the Dog and GroupPersons tables. I've tried re-adding the database to the project, 'running custom tool' to get the .tt files to execute again, and even deleting them and adding them back. I can get a simple project to build that perform simple querying and insertions, however I tried just now to change the primary key of a single Person, Dog, or Group and x.Save() but System.Data.SQLite threw an exception for all three, saying SQLite error near "WHERE":syntax error. at the Save().
 
Any suggestions for what I should try to do next?

原文：https://stackoverflow.com/questions/3552902