Foreign Keys - how to enable? vb.net
Posted: Wed 19 Apr 2017 03:06
In vb.net 2017 - SQLite - I can setup a connection like this:
_connection = New SQLiteConnection("Data Source=" & database & ";foreign_keys = true")
However - using dotConnect SQLite - I can not do it like this - errors.
Is there a simple way to turn it on? - because the help file is so confusing - you could try 100 different ways and still get it wrong. For the life of me - as common as fk's are - it should be something that is easily handled without reading through weeds of help - that doesn't show the (exact) correct example!
Thanks
_connection = New SQLiteConnection("Data Source=" & database & ";foreign_keys = true")
However - using dotConnect SQLite - I can not do it like this - errors.
Is there a simple way to turn it on? - because the help file is so confusing - you could try 100 different ways and still get it wrong. For the life of me - as common as fk's are - it should be something that is easily handled without reading through weeds of help - that doesn't show the (exact) correct example!
Thanks