On 24 Sep 2016, at 10:14am, denis <dc4...@gmail.com> wrote: > Hello all, I want enabling foreign key in the file app.config of visual > studio 2015 is-it possible? if yes, what is the string? > I tested connectionString = "data source=d:\db.sqlite; ForeignKeys=true;" > but the FK does not work.
Just connect as normal, then execute the SQL command PRAGMA foreign_keys = ON That should do it. You should be able to test it using PRAGMA foreign_keys and see what the response is. If you get nothing back then check which version of SQLite you're using: versions before 3.6.19 don't support foreign keys. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
