sqlite-net
sqlite-net copied to clipboard
praeclarum
There is no FK Attribute support!
Foreign Key Constraints are vital feature of any ORM.
- Class Column: need to be added FK property && colAttribute like [Association(TableName = "ACCOUNT"].
- Class TableMapping shoud implement FK supporting
- Class ORM should implement new case like "p.IsFK" and decl like "REFERENCES ACCOUNT"
After that implementation we can get creating tables with FK. So Second part of modification must be geting data with joins due FK.
Is there any update or plan for FK support? What about support for table relationships? (one to many/many to many, etc) Thanks in advance,
SQLite states that foreign keys are disabled by default, what if we pass these options
"PRAGMA foreign_keys = true"
as
var options = new SQLiteConnectionString(databasePath,
true,
somekey,
preKeyAction: db => db.Execute("PRAGMA foreign_keys = true"));
Will it work?
