StatementBuilder Class

Definition

Namespace:

Microsoft.SqlServer.Management.Sdk.Sfc

Assembly:

Microsoft.SqlServer.Management.Sdk.Sfc.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

constructs the tsql that will get the data

[System.Runtime.InteropServices.ComVisible(false)]
public class StatementBuilder

[<System.Runtime.InteropServices.ComVisible(false)>]
type StatementBuilder = class

Public Class StatementBuilder

Inheritance

Object

StatementBuilder

Attributes

ComVisibleAttribute

Constructors

StatementBuilder()

default constructor

Properties

Distinct	the select must be distinct
From	returns the FROM clause
IsFirstJoin	this is the first table added to the from clause
SqlPostfix	get the postfix statement
SqlStatement	compute the whole sql statement ( including prefix / postfix )

Methods

AddCondition(String)	add a CONDITION which if is true will make the result set be empty
AddElement(StringBuilder, String, String, String, String)	adds value to a string builder using the specified delimiters
AddFields(String)	add to the SELECT fields list
AddFrom(String)	add a clasic join to the FROM clause
AddJoin(String)	add a new syntax join to the FROM clause
AddOrderBy(String, String, OrderBy+Direction)	add to ODER BY clause by name if the property apears in the SELECT list if not add it by value
AddOrderBy(String)	add to the ORDER BY clause
AddPostfix(String)	add to POSTFIX
AddPrefix(String)	add to PREFIX
AddProperty(String, String)	add property to the SELECT list with alias
AddUrn(String)	add to URN
AddWhere(String)	add to the WHERE clause using AND
ClearFailCondition()	clear the CONDITION which if true makes the result be enpty
GetSqlNoPrefixPostfix()	clear the prefix and postfix and get the remaining sql statement
IsEmpty(StringBuilder)	returns true if s is empty
MakeCopy()	make a copy of this StatementBuilder
Merge(StatementBuilder)	merge two StatementBuilder instances