Page 1 of 1

Using table definitions without foreign key check

Posted: Mon 30 Nov 2020 22:41
by chris185
Hi,

I have an App which runs in 2 modes, 1 mode is database mode where the App connects to an database. 2. is standalone mode where i want to store the same data locally as lists in files. When i use standalone mode i want to reuse the database objects, but the problem is that the data will not be populated correct. The foreign key constraint seems to avoid that the data will be filled up. Can i disable foreign key checks without connecting to the database ?

Sincerly
Christoph Weller

Re: Using table definitions without foreign key check

Posted: Sat 12 Dec 2020 16:12
by Shalex
You are using MySqlDataSet in standalone mode, aren't you? Try setting MySqlDataSet.EnforceConstraints=false. If this is not the case, send us a small test project so that we can reproduce the issue you have encountered.