xSQL Schema Compare SDK for SQL Server version 12
EntitySchemaFilterCondition Class
Members  Example 


Represents a filter condition that is evaluated against the schema of an object.
Object Model
EntitySchemaFilterCondition Class
Syntax
'Declaration
 
Public NotInheritable Class EntitySchemaFilterCondition 
   Inherits EntityFilterCondition
   Implements IEntityFilterEvaluator 
public sealed class EntitySchemaFilterCondition : EntityFilterCondition, IEntityFilterEvaluator  
public __gc __sealed class EntitySchemaFilterCondition : public EntityFilterCondition, IEntityFilterEvaluator  
Example
The following code creates a database function filter. The filter contains two conditions that select only the functions that belong to the schema Sales or HumanResources. Since a function can belong to either one of the schemas, the filter group to which the conditions belong combines them with the OR operator:
EntityFilter functionFilter = new EntityFilter(SqlEntityTypeEnum.UserDefinedFunction);
EntityFilterGroup group = new EntityFilterGroup(functionFilter); 
                       
// combine the conditions in the group with the OR operator
group.ConditionOperator = EntityFilterOperatorEnum.OR;
                       
// add the group conditions; both conditions require an exact match of the schema, so the EqualsTo condition type is used
group.Conditions.Add(new EntitySchemaFilterCondition("Sales", EntityFilterConditionTypeEnum.EqualsTo, group));
group.Conditions.Add(new EntitySchemaFilterCondition("HumanResources", EntityFilterConditionTypeEnum.EqualsTo, group));
            
functionFilter.Groups.Add(group);
Inheritance Hierarchy

System.Object
   xSQL.Schema.SqlServer.Filter.EntityFilterCondition
      xSQL.Schema.SqlServer.Filter.EntitySchemaFilterCondition

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

EntitySchemaFilterCondition Members
xSQL.Schema.SqlServer.Filter Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback