![]() ![]() It seems that the FKTables attribute for each table is not assigned in the file "SQLite.ttinclude". at the Save().Īny suggestions for what I should try to do next? 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 threw an exception for all three, saying SQLite error near "WHERE":syntax error. tt files to execute again, and even deleting them and adding them back. I've tried re-adding the database to the project, 'running custom tool' to get the. 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. INTEGER NOT NULL CONSTRAINT REFERENCES () ON DELETE CASCADE ON UPDATE CASCADE,ĬONSTRAINT PRIMARY KEY (, )) INT NOT NULL CONSTRAINT REFERENCES () ON DELETE CASCADE ON UPDATE CASCADE, INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Here's the DDL SQLite Expert spits out for my small database: I made some dummy tables to try to test out how SubSonic handles one:many and many:many relationships. I created the database using SQLite Expert Personal 3. ![]() Additionally, each Foreign Keys region is empty within each generated ActiveRecord class. Looking inside Structs.cs, IsForeignKey is always false for every column, even the ones I have a foreign key defined for. 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. tt files to recognize and generate code for the foreign keys and relationships in my SQLite database. I'm using SubSonic 3.0.0.3 and I can't seem to get the ActiveRecord.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |