SQLite and foreign keys

I found a place in the documentation that says DON does not support foreign keys in SQLite. Based on a simple test, it appears that is the case. SQLite has had support for foreign keys since 3.6.19 (2009-10-14). Is this a technical limitation of DON? Is there an option that enables foreign keys? Is this something DON will support in the future?

Thanks!

sqlite foreign-keys

asked Oct 28 '14 at 10:04

TimB
7●5●5●8

Thank you for the quick response. Is it possible to intercept and modify the DDL generated by Domain.Build()? If so, I can insert the required syntax for a foreign key.

(Oct 29 '14 at 09:58) TimB

One Answer:

oldest newest most voted

Hello TimB

Yes, it's DataObjects.Net limitation. Sorry but, there is no any option to enables foreign keys for SQlite. Maybe in future we'll add foreign keys support. But actually I don't know when, because we have another features and improvements with higher priority status.

answered Oct 29 '14 at 08:47

Alexey Kulakov
772●2●5

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

foreign-keys ×9
sqlite ×4

Asked: Oct 28 '14 at 10:04

Seen: 3,833 times

Last updated: Oct 29 '14 at 09:58

Subscription:

Related questions