1. I am a dot net programmer for past 13 years
2. I can do this with MS SQL compact db
My understanding of work is as follows
1. I have to use the existing attached web service to do the external query
2. Before doing the external query
A. If user invokes GETIPDetails, after the IP null check query db to see whether history data exists
If data exists, this should be presented to user
else, get data from json, and insert the data back to local db and send the response to called user
B . if user invokes GetIPDetailsNew, use the same logic detailed above