how to resolve 'BitwiseAndOperator' problem and what are the resons for its occurence

Hi,

I am facing 'BitwiseAndOperator' in following lightspeed query. following is error message

 Dim SaleID = (From P In ContextFactory.Repo.tablename Where _
 P.ProjectPmAuctionSalesId = hfAuctID.Value And P.SaleAmntHighBid <> Nothing _
 Select P.name).SingleOrDefault()

Eror  Message:

Object reference not set to an instance of an object.   at Mindscape.LightSpeed.Linq.Operators.BitwiseAndOperator.Apply(QueryExpression lhs, QueryExpression rhs, DataProvider provider)
   at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractBinaryCriteria(IList`1 rangeVariables, QuerySubexpressionCollection subexpressions, BinaryExpression expression)
   at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(IList`1 rangeVariables, QuerySubexpressionCollection subexpressions, Expression expression)
   at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(IList`1 rangeVariables, QuerySubexpressionCollection subexpressions, Expression expression)
   at Mindscape.LightSpeed.Linq.Sqo.CriteriaSqo.ExtractCriteria(IList`1 rangeVariables, QuerySubexpressionCollection subexpressions, Expression expression)
   at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
   at Mindscape.LightSpeed.Linq.Sqo.Select.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
   at Mindscape.LightSpeed.Linq.Sqo.Single.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression)
   at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp)
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.GetExecutionPlan(Expression expression)
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression)
   at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)

Thanks for drawing our attention to this, this was a bug within our VB.NET LINQ translation code and I have put in a fix which will be available in the next nightly build (20110207).

Jeremy

 thanx Jeremy, i justy have to replase old dll with new dll to over come from this problem, right?

and I just have one more question, i am using above statement at different events on same page but i got this error only at some places, not at every statement.

Yes, you will want to install the nightly and then you can use the new binaries. The difference may be if the expression deals with nullable bools as this was what the specific issue was triggered by.

Jeremy