Reversing a Condition with the Not Operator

This example introduces the EntityBooleanOp.NOT operator, which reverses the sense of a condition.  Like the OR operator, the NOT operator is applied after the clause to which it applies has been defined.

C#

#region Name Does ! (Contains the Letter 'E') /// <remarks> /// select * from "dbo"."Product" where (( not "dbo"."Product"."ProductName" like ?)) /// Params: v0=%E% /// </remarks> internal static RdbQuery GetQueryNameDoesNotContainsE() {   RdbQuery query = new RdbQuery(typeof(Product));   query.AddClause(Product.ProductNameEntityColumn, EntityQueryOp.Contains, "E");   query.AddOperator(EntityBooleanOp.Not);   return query; } #endregion

VB

#Region "Name Does NOT Contains the Letter 'E'"   ''' <remarks>   ''' select * from "dbo"."Product" where (( not "dbo"."Product"."ProductName" like ?))   ''' Params: v0=%E%   ''' </remarks>   Friend Shared Function GetQueryNameDoesNotContainsE() As RdbQuery     Dim query As New RdbQuery(GetType(Product))     query.AddClause(Product.ProductNameEntityColumn, EntityQueryOp.Contains, "E")     query.AddOperator(EntityBooleanOp.Not)     Return query   End Function #End Region