René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Key not found in dictionary on multiple booleans in where","articleBody":"```\nFirst of all, great job on this, I was actually doing it myself as well, but \nended up getting extremely messy and did not get as far as you did, ended up \nscrapping it and using this.\n\nOnly issue I am having is the following query:\n\nquery.Where(x =\u003e (x.IsActive || x.IsLocked) \u0026\u0026 x.EmailAddress == \n\"test@test.com\");\n\nIs giving the following error:\n\nSystem.Collections.Generic.KeyNotFoundException : The given key was not present \nin the dictionary.\n\nat System.Collections.Generic.Dictionary`2.get_Item(TKey key)\n   at Resolver.LambdaResolver.BuildSql(MemberNode leftMember, MemberNode rightMember, ExpressionType op) in LambdaResolverTree.cs: line 80\n   at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid4\u003cT0,T1,T2,T3\u003e(CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3)\n   at Resolver.LambdaResolver.BuildSql(OperationNode node) in LambdaResolverTree.cs: line 46\n   at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid2\u003cT0,T1\u003e(CallSite site, T0 arg0, T1 arg1)\n   at Resolver.LambdaResolver.BuildSql(Node leftNode, Node rightNode, ExpressionType op) in LambdaResolverTree.cs: line 99\n   at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid4\u003cT0,T1,T2,T3\u003e(CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3)\n   at Resolver.LambdaResolver.BuildSql(OperationNode node) in LambdaResolverTree.cs: line 46\n   at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid2\u003cT0,T1\u003e(CallSite site, T0 arg0, T1 arg1)\n   at Resolver.LambdaResolver.ResolveQuery(Expression`1 expression) in LambdaResolverQuery.cs: line 18\n   at LambdaSqlBuilder.SqlLam`1.And(Expression`1 expression) in SqlLam.cs: line 47\n   at LambdaSqlBuilder.SqlLam`1.Where(Expression`1 expression) in SqlLam.cs: line 41\n   at Tests.ExpressionTests.WhereMultipleBoolAndElse_Should_ReturnQuery() in ExpressionTests.cs: line 364\n\n\nThe only workaround I was able to do is add \"== true\" to both booleans, however \nif I only did 1 boolean, it works fine\n\nExample..\nquery.Where(x =\u003e (x.IsActive || x.CreatedOn == date) \u0026\u0026 x.EmailAddress == \n\"test@test.com\");\n\nThis one works without issue\n```\n\nOriginal issue reported on code.google.com by `lee...@leehull.com` on 14 Feb 2014 at 2:09\n","author":{"url":"https://github.com/GoogleCodeExporter","@type":"Person","name":"GoogleCodeExporter"},"datePublished":"2016-01-13T12:37:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2/lambda-sql-builder/issues/2"}