c# - Local database choice (Windows Phone 8.1 application) -

i in process of making relatively complex windows phone 8.1 application , need way store data server's database local database. data server retrieved in json format via api. options here? i've tried sqlite database controlled sqlite-net lacks key features such foreign keys support , 64bit support (?). other choices have? local database used in order give user ability work offline , later sync data local database server's database.

i suggest portable class library sqlite microsoft open technologies, inc. can install project visual studio nuget package manager.

using sqlitepcl easy. library mimics c/c++ interface of sqlite. can find details of interfaces here: https://www.sqlite.org/cintro.html