You have to handle the deletion manually in some way or another: delete entry from Ignite when deleting it from DB, or use some DB change listener.
On Wed, May 31, 2017 at 1:13 PM, Chetan D <ccheta...@gmail.com> wrote: > Hi Pavel, > > I was going through all methods and trying to implement cache using > ado.net while doing that i came across some scenario which are as follows, > > 1.Data is added to cache and when trying to retrieve it using key first it > checks if it is present in cache then gets it from cache if not then there > will be a db call and fetches the data from DB and stores it in cache which > again follows for the next time as well. > > 2. The second scenario is i have loaded cache with two values from DB > taking your cars table as example.Once i have loaded cache then i went > ahead and deleted a record from DB. > so when i use a get() method by passing the key which i deleted in DB it > actually shows me the value which because it is present in cache. > > so my question is when there is a record deleted in DB it should be > deleted in cache. when user tries to retrieve any information which is not > there in DB it should not be displayed from cache as well. > > > Can you please guide me how to handle this. > > Regards > Chetan D > > > > On Tue, May 30, 2017 at 5:36 PM, Pavel Tupitsyn <ptupit...@apache.org> > wrote: > >> Basically, data streamer does the same thing as cache.Put() in a loop. >> Data streamer is more efficient on large amounts of keys. >> >> 1) Yes, I guess there is no different than using tables >> 2) Data streamer performs batched updates. IDataStreamer.PerNodeBufferSize >> controls how many entries are batched before being sent to remote nodes. >> 3) Once the streaming is complete (IDataStreamer.Flush() or >> IDataStreamer.Close(false)), all data is guaranteed to be in the cache. So >> you can do cache.Get. >> >> On Tue, May 30, 2017 at 2:49 PM, Chetan D <ccheta...@gmail.com> wrote: >> >>> 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/ >>>>>> >>>>>> >>>>> >>>> >>> >> >
