how to save custom object into sqlite database on windows phone8 using c#? -

how to save custom object into sqlite database on windows phone8 using c#? -

how save custom object sqlite database on windows phone8 using c#?

public class person { public int id { get; set; } public string name { get; set; } public string surname { get; set; } public list<address> items { get; set; } public list<subaddress> subaddress { get; set; } } public class address { public string city { get; set; } public string state { get; set; } public string pin { get; set; } public list<subaddress> subaddress { get; set; } } public class subaddress { public string subaddresscity { get; set; } public string subaddressstate { get; set; } public string subaddresspin { get; set; } } person person = new person { name = "matteo", surname = "pagani", items = new list<address> { new address { city="fdsdf",state="sfds",pin="dsfsd",subaddress=new list<subaddress> { new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" } }, }, new address { city="fdsdf",state="sfds",pin="dsfsd",subaddress=new list<subaddress> { new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" } } }, new address { city="fdsdf",state="sfds",pin="dsfsd",subaddress=new list<subaddress> { new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" } } }, new address { city="fdsdf",state="sfds",pin="dsfsd",subaddress=new list<subaddress> { } } }, subaddress = new list<subaddress> { new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" }, new subaddress { subaddresscity="llll", subaddressstate="ffff", subaddresspin="gggg" } } };

how save person object straight database , how retrieve object ?

is possible or not possible can please help me accomplish .

thanks ......

your question broad. @ first, should larn - how store objects in tables. then, how store complex objects in tables etc. it's impossible reply few lines of text. general understanding of sql databases required.

c# windows-phone-8 sqlite3