xSQL Schema Compare SDK version 9.5 for SQL Server
EntityFilterGroup Class
Members  Example 


Represents a group of conditions combined with an operator.
Object Model
EntityFilterGroup Class
Syntax
'Declaration
 
Public NotInheritable Class EntityFilterGroup 
   Implements IEntityFilterEvaluator 
public sealed class EntityFilterGroup : IEntityFilterEvaluator  
public __gc __sealed class EntityFilterGroup : public IEntityFilterEvaluator  
Remarks
A filter group contains conditions combined with one specific operator. The following rules apply to the operator: Depending on the property IncludeMatches, the group can either include or exclude database objects that meet its conditions.
Example
The following code creates a group that is part of a view filter. The group excludes the views the name of which starts with "temp" or ends with "tmp":
EntityFilter viewFilter = new EntityFilter(SqlEntityTypeEnum.View);
EntityFilterGroup group = new EntityFilterGroup(viewFilter);
                        
// combines the conditions in the group with the OR operator
group.ConditionOperator = EntityFilterOperatorEnum.OR;
                        
// the group should EXCLUDE the views that match the conditions
group.IncludeMatches = false;
                        
// add the group conditions
group.Conditions.Add(new EntityNameFilterCondition("temp", EntityFilterConditionTypeEnum.StartingWith, group));
group.Conditions.Add(new EntityNameFilterCondition("tmp", EntityFilterConditionTypeEnum.EndingWith, group));
                        
viewFilter.Groups.Add(group);
Inheritance Hierarchy

System.Object
   xSQL.Schema.SqlServer.Filter.EntityFilterGroup

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

EntityFilterGroup Members
xSQL.Schema.SqlServer.Filter Namespace

 

 


┬ęCopyright 2018 xSQL Software. All Rights Reserved.

Send Feedback