If you want to save the entire data set, there is always a caching method that allows you to store a huge variable with good performance. Here is an example of how you can save a variable in Cache.
Cache["CacheItem1"] = "Cached Item 1";
And this is how to extract the variable after:
string cachedString; cachedString = (string)Cache["CacheItem"];
source share