I am using latest dotConnect for sqlite and I cannot execute a query like 'SELECT * FROM TABLE' because I get an exception
"Cannot remove this column, because it is a part of the constraint Constraint1 on the table ."
Table has only one primary key it has not any constraint.
How can I detect what is wrong with table or how can I switch automatic constraints?
I build connectionstring in that way but it does not help
SQLiteConnectionStringBuilder sqlBuilder = new SQLiteConnectionStringBuilder();
sqlBuilder.DataSource = m_path;
sqlBuilder.IgnoreCheckConstraints = true;
sqlBuilder.AutomaticIndex = false;
sqlBuilder.ForeignKeyConstraints = SQLiteForeignKeyConstraints.Off;
How can I switch constaints off?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
We could not reproduce the issue. Could you please post here:
1. The DDL/DML scripts (or send us a test SQLite database);
2. A snippet of code where you create the connection and the command which invoke the issue;
1. The DDL/DML scripts (or send us a test SQLite database);
2. A snippet of code where you create the connection and the command which invoke the issue;