How to map entities associations without foreign keys?

Last post 10-27-2009 7:02 AM by Nate. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

10-26-2009 5:55 PM

ValTrof
Joined on 10-27-2009
Posts 1

How to map entities associations without foreign keys?

Reply Contact

As far as I know, SQLite doesnt allow foreing keys. But I need them to map associations between entities. Is there a way to do it somehow anyway?

Filed under: EF, association, entity framework, entities, mapping

10-27-2009 7:02 AM In reply to

Nate
Joined on 08-28-2005
Fort Collins, CO
Posts 93

Re: How to map entities associations without foreign keys?

Reply Contact

Foreign keys are now supported although the ADO .NET Provider here does not yet include it: http://www.sqlite.org/releaselog/3_6_19.html As far as needing associations, go ahead and create the foreign keys. Even though SQLite will not enforce the foreign keys the associations will be created.

Page 1 of 1 (2 items)

System.Data.SQLite