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.

 

D.