Saturday, April 22, 2017

Traveller Tracker - Foreign Keys

After the initial jubilation of being able to use SQLite with Entity Framework in a UWP application, I was dismayed to discover that foreign keys are not supported in SQLite.  EF has some nice tooling for database migrations, but sadly they will not work.

There are workarounds, which is what I am probably going to end up doing. I just have to be careful about the naming conventions so I don't accidently create a FK in the models.

But I have learned how to add additional tables into the migration path, and now knowing about some of the limitations, I can work around them. 

I must be getting excited by all this again - had the strangest dreams about the code base last night. Or perhaps that was the carrot cake...

No comments: