You could use a local SQL CE (4.0 version only for ASP.NET support) database for disconnected scenarios and then use Microsoft Sync Framework to sync the data once online. The code to make all of it seamless might take a little work, but it is a viable option.
atconway
All-Star
16846 Points
2756 Posts
Re: Local database cache for web application
Apr 29, 2012 11:59 PM|LINK