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!

asked Oct 28 '14 at 10:04

TimB's gravatar image

TimB
7458

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 TimB's gravatar image

One Answer:

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%20Kulakov's gravatar image

Alexey Kulakov
45215

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

powered by OSQA