I found out recently that sometimes on a per-session basis, you have to
turn the foreign key check on. So even though one provider has it on by
default, another may not.
http://www.sqlite.org/pragma.html#pragma_foreign_keys
I had a SQLite3 Database manager running, and the SQL to delete a row fr
David Richardson wrote:
> I’m having some sort of bug with system.data.sqlite.
> when I try to delete it should cascade , but 'on cascade delete’ does NOT
> work.
In SQLite, it's called "on delete cascade":
sqlite> pragma foreign_keys=on;
sqlite> create table parent(id integer primary key);
sqli
Hi community
I’m having some sort of
bug with system.data.sqlite. I’ve been trying for weeks now! I’ve installed
(System.Data.SQLite 1.0.81.0) and
i’m using sqlite in combination with Entity Framework 4. Mostly it does what I
want. The only problem I’m having is that when I try to delete it sho
3 matches
Mail list logo