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
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);
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
3 matches
Mail list logo