SqlPropertyLink Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:: Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

class encapsulating a property_link used do indicate joins

[System.Runtime.InteropServices.ComVisible(false)]
public class SqlPropertyLink : Microsoft.SqlServer.Management.Sdk.Sfc.ConditionedSql

[<System.Runtime.InteropServices.ComVisible(false)>]
type SqlPropertyLink = class
    inherit ConditionedSql

Public Class SqlPropertyLink
Inherits ConditionedSql

Inheritance: Object

ConditionedSql
SqlPropertyLink

Attributes: ComVisibleAttribute

Constructors

SqlPropertyLink(XmlReadProperty)	initialize by reading a property tag ( attribute table )
SqlPropertyLink(XmlReadPropertyLink)	initialize with reader from xml by reading a property_link tag
SqlPropertyLink(XmlReadSettings)	initialize by reading a setting tag ( attribute main_table )

Properties

AcceptsMultipleHits	can be added multiple times (Inherited from ConditionedSql)
Fields	get the list of triggering fields (Inherited from ConditionedSql)
IsUsed	is this conditioned sql already used ? ( important because it can be used only once ) (Inherited from ConditionedSql)
LinkFields	get the list of fields for which we need their value (Inherited from ConditionedSql)
LinkMultiple	get the link multiple (Inherited from ConditionedSql)
Table	get set the joined table name
Used	has been added at least once (Inherited from ConditionedSql)

Methods

Add(ConditionedSqlList, XmlReadProperty)	add from a property tag
Add(ConditionedSqlList, XmlReadSettings)	add from setting tag
AddAll(ConditionedSqlList, XmlReadPropertyLink)	add all property_link tags
AddHit(String, SqlObjectBase, StatementBuilder)	add hit for this field update the StatementBuilder
AddLinkMultiple(XmlReadMultipleLink)	intialize link multiple (Inherited from ConditionedSql)
ClearHit()	mark this sql as not used (Inherited from ConditionedSql)
GetFilter(SqlObjectBase)	get the filter for the join
GetTableNameWithAlias(SqlObjectBase)	get the table name with alias in tsql format
IsDefault()	this sql must always be added no matter what fields are requested (Inherited from ConditionedSql)
IsHit(String)	return true if the field has caused the sql to be added (Inherited from ConditionedSql)
MarkHit()	mark this sql as used (Inherited from ConditionedSql)
SetFields(StringCollection)	set the triggering fields (Inherited from ConditionedSql)
TestHit(String)	test if the field would make the tsql to be added ( it does not look if it was already used ) (Inherited from ConditionedSql)

Applies to

Partilhar via