http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : Error in cache query Sat, 11 Apr 2026 17:54:25 -700 Fri, 09 Nov 2012 12:17:49 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3782 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15167#15167 Author: kimj
Subject: 3782
Posted: 09-Nov-2012 at 12:17pm

I'm not able to reproduce a scenario where the visitor is ever receiving a null Expression argument in this method, so I'm afraid I'm going to need to see the code for how you build up this query.  If you don't wish to post it here you can PM or email me.]]> Fri, 09 Nov 2012 12:17:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15167#15167 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15159#15159 Author: smi-mark
Subject: 3782
Posted: 08-Nov-2012 at 6:20pm

Selector:   System.Func<System.Linq.IQueryable<RefundTrac.Model.RefundQueue>,System.Linq.IQueryable<RefundTrac.Model.Projections.RefundListItem>>

Predicate:
u => ((True AndAlso u.Refund.TaxAccountNumber.Contains(value(RefundTrac.DomainServices.Services.Queue.QueueSearchService+<>c__DisplayClass2).str)) AndAlso (u.UserId == value(RefundTrac.ViewModels.Queue.QueueSearchViewModel).User.UserId))}    System.Linq.Expressions.Expression<System.Func<RefundTrac.Model.RefundQueue,bool>>

Final query

value(IdeaBlade.EntityModel.EntityQueryProxy`1[RefundTrac.Model.RefundQueue]).Where(u => ((True AndAlso u.Refund.TaxAccountNumber.Contains(value(RefundTrac.DomainServices.Services.Queue.QueueSearchService+<>c__DisplayClass2).str)) AndAlso (u.UserId == value(RefundTrac.ViewModels.Queue.QueueSearchViewModel).User.UserId))).Select(q => q.Refund).Select(q => new RefundListItem() {RefundId = q.RefundId, Amount = q.Amount, Status = q.RefundStatus, Step = q.CurrentStep, RefundType = q.RefundType, TaxAccount = q.TaxAccountNumber, CreateDate = q.CreateDate, PayeeName = IIF(q.RefundPayees.Any(), q.RefundPayees.FirstOrDefault().Name1, "Unassigned"), LastUser = IIF(q.RefundAudits.Any(), q.RefundAudits.OrderByDescending(a => a.AuditDate).Select(a => a.AuditUser).FirstOrDefault(), String.Empty), LastUpdate = IIF(q.RefundAudits.Any(), q.RefundAudits.OrderByDescending(a => a.AuditDate).Select(a => Convert(a.AuditDate)).FirstOrDefault(), null)})}    IdeaBlade.EntityModel.IEntityQuery<RefundTrac.Model.Projections.RefundListItem> {IdeaBlade.EntityModel.EntityQuery<RefundTrac.Model.Projections.RefundListItem>

]]> Thu, 08 Nov 2012 18:20:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15159#15159 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15158#15158 Author: kimj
Subject: 3782
Posted: 08-Nov-2012 at 5:57pm

Do you have a snippet of your query?]]> Thu, 08 Nov 2012 17:57:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15158#15158 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15157#15157 Author: smi-mark
Subject: 3782
Posted: 08-Nov-2012 at 3:03pm

Not sure why this is happening yet but I've found an exception when querying cache. The problem is in CacheQueryExpressionVisitor

me = String.Empty
expr = null

I've never seen this before as we usually search against the database - this time it is in cache. If I make it go to the datasource, it works fine.




Edited by smi-mark - 08-Nov-2012 at 3:06pm]]> Thu, 08 Nov 2012 15:03:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3782&PID=15157#15157