Devart Forums

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;

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;