sqlite, how to avoid insert new record when I delete parent? I use C# and EF 4.4

Question

Well, in SQLLite there is not exist the possibility to delete on cascade, or I don't know how.

Imagine that I have two tables, Table A and Table B. The table B has the IDtableA field, because is a child, and imagine that I have the following situation:

1.- user A load record 1 from TableA and load it in the context. 2.- user A load all the child records from table B. 3.- user B add a new record to table B that is child of table A. 4.- user A save changes and delete record 1 and all the childs that he loaded in the first time, but not include the new child add by the user B.

So in SqlLite I don't have a model, neither realationships between tables, when user B add a new child, not check if the parent exists.

is it posible ensure reference integrity in Sqlite?

Thanks.

Your reputation was not found (404) but it found it to you by upvoting your question :) :) it is 411 now :) — Saw
– Saw, Commented Dec 16, 2012 at 10:15

Community · Accepted Answer · 2017-05-23 12:21:29Z

3

SQLite supports foreign keys and "on delete cascade", but in the new versions.

You can see this article in official SQLite website:

sqlite.org/foreignkeys.html

The say:

This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19.

Also, you have to explicitly enable foreign keys for every connection.

this question may help you: Enabling Foreign key constraints in SQLite

You can do it by changing the connection string and add:

foreign keys=true;

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Dec 16, 2012 at 10:22

Saw

6,45412 gold badges60 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite, how to avoid insert new record when I delete parent? I use C# and EF 4.4

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related