using System; using System.Linq; using System.Linq.Expressions; using System.Diagnostics; using System.Collections.Generic; using SqlLinq.SyntaxTree.Expressions; using SqlLinq.SyntaxTree.Aggregates; namespace SqlLinq.SyntaxTree.Clauses { [SyntaxNode(RuleConstants.RULE_WHERECLAUSE_WHERE)] public class WhereClause : NonTerminalNode { public WhereClause() { } public Func<IEnumerable<T>, T, bool> CreateEvaluator<T>() { ExpressionNode predicate = FindChild<ExpressionNode>(); if (predicate != null) { var sourceData = Expression.Parameter(typeof(IEnumerable<T>)); return predicate.CreatePredicateFunction<T>(sourceData); } // shouldn't get here but... // any other expression in the where clause evaluates to true Debug.Assert(false); return (e, t) => true; } internal override void CheckSyntax() { // filter out any aggregates expressions in a where clause that are not part of a sub-query if (FindDescendants<AggregateNode>().Where(a => (!(a.Parent is Columns) && !(a.Parent.Parent is Columns))).Any()) throw new SqlException("Aggregate expressions are not valid in a WHERE clause.\nTry GROUP BY and HAVING instead."); } } }
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
10 PRINT "Don is cool" 20 GOTO 10