Hi Pavel, Thank you for the quick response. I tried using data streamer to get all the values in a table and store it in cache. while i was doing that i came across a situation where in i need to store data to cache from SQL VIEWS.
1.Is it possible to load cache from sql views? 2.with respect to data streamer, when i use AddData() method will it add data to cache which i specified while creating data streamer or the data will be stored in data streamer itself? 3. when i use data streamer can i use the same way such as cache.get() method or by using a foreach loop to get cache or is it different with respect to datastreamer? Regards Chetan D On Mon, May 29, 2017 at 6:45 PM, Pavel Tupitsyn <ptupit...@apache.org> wrote: > 1) ICache implements IEnumerable, so you can do `foreach (var entry in > cache)` or `cache.ToList()`. > 2) To bulk load the data into cache you can either use IDataStreamer [1] > or, in case with cache store, ICacheStore.LoadCache method. > 3) No, you have to handle this manually. > 4) GetAll returns multiple cache entries by a set of known keys. > > [1] https://apacheignite-net.readme.io/docs/data-streamers > > On Mon, May 29, 2017 at 3:28 PM, Chetan D <ccheta...@gmail.com> wrote: > >> Hi Pavel, >> >> Thanks for the quick response. code helped me a lot. >> I have some general questions, >> >> 1.is it possible to get all data stored in cache without calling >> explicit get method if so how? >> 2.can i fetch all data from sql table and store it in cache without using >> any of the loops such as for each. >> 3.if i add any data in table will my cache gets updated automatically? >> 4.how can i make use of GetAll() method? will this fetch all cache data? >> >> Regards >> Chetan D >> >> On Fri, May 26, 2017 at 10:36 PM, Pavel Tupitsyn <ptupit...@apache.org> >> wrote: >> >>> Short writeup with example code, inspired by user questions: >>> >>> ADO.NET + Binary Mode Cache Store >>> https://ptupitsyn.github.io/Ado-Net-Cache-Store/ >>> >>> >> >