DevForce Community Forum : Not able to query locally cached data http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Not able to query locally cached data Tue, 28 Apr 2026 16:37:44 -700 Fri, 17 Jul 2009 07:16:01 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1378 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Not able to query locally cached data : Thanks Kim -- I had not yet executed... http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4969#4969 Author: AdamC
Subject: 1378
Posted: 17-Jul-2009 at 7:16am

Thanks Kim -- I had not yet executed the query.  Now I feel a little silly.  :-)  I had removed an earlier query and subsequent execution code but never added it back.  I was seeing the cache file being created, but now I realize it doesn't mean actual data was saved.  I think that's what hung me up.  Looking at the cache file in a text editor with and without data shows a big difference.  Thanks again.

For anyone interested in what I changed, please see the line in red:


EntityQuery<LOCAL_STRING> localStringQuery = null;

localStringQuery =
    (from ls in domainEntityManagerService.DomainEntityManager.LOCAL_STRING
    select ls);

localStringQuery.Execute<LOCAL_STRING>();

domainEntityManagerService.DomainEntityManager.CacheStateManager.SaveCacheState("c:\localization.bin");

]]> Fri, 17 Jul 2009 07:16:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4969#4969 Not able to query locally cached data : My guess is that nothing was saved... http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4965#4965 Author: kimj
Subject: 1378
Posted: 16-Jul-2009 at 7:00pm

My guess is that nothing was saved to cache initially, or at least not what you expected.  I'm confused by the block of code used to save cache state - you declare a query and then save cache, but the query has not yet been executed.  ]]> Thu, 16 Jul 2009 19:00:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4965#4965 Not able to query locally cached data : Hi,I&#039;m not able to retrieve... http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4962#4962 Author: AdamC
Subject: 1378
Posted: 16-Jul-2009 at 3:14pm

Hi,

I'm not able to retrieve data I've cached locally.  The second block of code (below) works fine when I am connected to the database.  However, when I am notconnected to the database I get a "Sequence contains no elements"error.  The stack trace is at the bottom.

Here is the code used to save the cache state (seems to work fine):

        EntityQuery<LOCAL_STRING> localStringQuery = null;

        localStringQuery =
            (from ls in domainEntityManagerService.DomainEntityManager.LOCAL_STRING
            select ls);

        domainEntityManagerService.DomainEntityManager.CacheStateManager.SaveCacheState("c:\localization.bin");


Here is the code used to query the table/cache.  The RestoreFromCache()method works fine -- it is the line in red throwing theexception.  I may be going about this the wrong way, so hopefullysomeone can't point me in the right direction.  Is it not possible to use LINQ queries against locally cached data?  Thanks!

        private EntityQuery<LOCAL_STRING> localStringQuery = null;
        public object GetValue(string localKey)
        {
            try
            {
                if (domainEntityManagerService.DomainEntityManager.IsConnected == false &&
                    domainEntityManagerService.DomainEntityManager.IsLoggedIn == false)
                {
                    domainEntityManagerService.DomainEntityManager.DefaultQueryStrategy = QueryStrategy.CacheOnly;
                    domainEntityManagerService.DomainEntityManager.CacheStateManager.RestoreCacheState("c:\localization.bin");
                }

                localStringQuery =
                    (from ls in domainEntityManagerService.DomainEntityManager.LOCAL_STRING
                     where ls.LOCAL_KEY == localKey
                     select ls);

                return localStringQuery.First().LOCAL_TEXT;
            }
            catch ( Exception ex )
            {
                 ...
            }
            return null;
        }



"   at System.Linq.Enumerable.First[TSource](IEnumerable`1source)\r\n   at lambda_method(ExecutionScope )\r\n   atSystem.Linq.EnumerableExecutor`1.Execute()\r\n   atSystem.Linq.EnumerableExecutor`1.ExecuteBoxed()\r\n   atSystem.Linq.EnumerableQuery`1.System.Linq.IQueryProvider.Execute(Expressionexpression)\r\n   atIdeaBlade.EntityModel.v4.EntityQuery`1.ExecuteCacheQuery(GuidqueryGuid)\r\n   atIdeaBlade.EntityModel.v4.EntityQueryFinder.ExecuteFind(GuidqueryGuid)\r\n   atIdeaBlade.EntityModel.v4.EntityQueryFinder.Execute()\r\n   atIdeaBlade.EntityModel.v4.EntityManager.ExecuteQueryCore(IEntityQueryquery, Boolean isAsync)\r\n   atIdeaBlade.EntityModel.v4.EntityManager.ExecuteQueryForObject(IEntityQueryquery)\r\n   atIdeaBlade.EntityModel.v4.EntityQuery`1.System.Linq.IQueryProvider.Execute[TResult](Expressionexpression)\r\n   at System.Linq.Queryable.First[TSource](IQueryable`1source)\r\n   atJenzabar.EX.Infrastructure.Localization.LocalizationProvider.GetValue(StringlocalKey) in C:\\Documents andSettings\\...\\LocalizationProvider.cs:line 79"
]]> Thu, 16 Jul 2009 15:14:47 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1378&PID=4962#4962