Correct way to setup foreign key support.

Apr 26, 2012 at 12:48 PM

Hi all,

  Are there any tutorials anywhere that show how best to setup a master/detail scenario using foreign keys.

So for example if I have the following...

public class Parent : IBusinessEntity
		public Parent ()
		/// <summary>
		/// Gets or sets the Database ID.
		/// </summary>
		/// <value>
		/// The ID.
		/// </value>
		[PrimaryKey, AutoIncrement]
                public int ID { get; set; }
	        public string Name { get; set; }
                public string Surname { get; set; }
                public List<Child> Children 


How can I get the Child objects to auto-populate from a json requst. Will then be saving this heirachy to a SQLLite DB.

I'm sure it is something simple, but I can't see the woods for the code, right now.