title: Apache ignite loadCache() with filter or predicate conditions with generics
body: <p>I am looking for .net/C# implementation where I can load the cache using Ignite.LoadCache() method to load with certain query operation only. Or to be more specific only load what is needed in cache instead all everything</p>
  <p>Right now I am loading cache with <code>null</code> as mentioned here <a href="http://ttps://apacheignite.readme.io/docs/3rd-party-store#section-loadcache-" rel="nofollow noreferrer">loadCache</a></p>
  <p>Here is my current implementation</p>
  <pre><code>public List&lt;TV&gt; Where&lt;TK, TV&gt;(Expression&lt;Func&lt;ICacheEntry&lt;TK, TV&gt;, bool&gt;&gt; query)
      {
          var cache =  _ignite.GetCache&lt;TK, TV&gt;(MyLocalCache);
  
          LoadCache(cache);
  
          var result = cache.AsCacheQueryable().Where(query);
      }
  
       private static void LoadCache&lt;TK, TV&gt;(ICache&lt;TK, TV&gt; cache)
      {
          
              cache.LoadCache(null);
      }
  </code></pre>
  <p>Also I am using SQL as my 3rd party persistence layer</p>