do you have xml scemas for the data that comes back from the web service calls ??
use SQL 2005 it supports storing xml and can search and index the data... then create a table or tables to relate the data to the call that got the data and wrap your calls with a class that checks for a local copy of the data and returns that when it's located
and calls the web service and saves it in the sql db when it has to get it the first time.
If you can explain the approach in more details that will be great.
if I have time later I will try to answer more questions but please start by
1) are the sibel web services xml based? soap? or ????
2) if they retrurn some kind of xml how many different xml formats do you need to read?
for example, Invoice, Quote, Workorder -- that would be 3
3) do you have access to sql server books ononline? (comes with sql or you can download from msft web site)
read up about sql 2005 and xml features....
you can manage the data several ways, not sure which is best in yur case .... but for example you can define a sql column as type XML
and store an xml doc or fragment in that.
you can be more detailed and if you provide a schema then sql server can use that to allow you to query the xml using a mix of xquery and sql.
so then just determine how you pick between saved data and fetching new data from a web service.
setup sql tables and save data to sql....
which no matter what framework you get you still have to make that part; when to use saved data Vs. get new data.