StatementBuilder Class

Do not reference this member directly in your code. It supports the SQL Server infrastructure.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Sdk.Sfc.StatementBuilder

Namespace:  Microsoft.SqlServer.Management.Sdk.Sfc
Assembly:  Microsoft.SqlServer.Management.Sdk.Sfc (in Microsoft.SqlServer.Management.Sdk.Sfc.dll)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Class StatementBuilder
'Usage
Dim instance As StatementBuilder
[ComVisibleAttribute(false)]
public class StatementBuilder
[ComVisibleAttribute(false)]
public ref class StatementBuilder
[<ComVisibleAttribute(false)>]
type StatementBuilder =  class end
public class StatementBuilder

The StatementBuilder type exposes the following members.

Constructors

  Name Description
Public method StatementBuilder Do not reference this member directly in your code. It supports the SQL Server infrastructure.

Top

Properties

  Name Description
Public property Distinct Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public property From Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public property IsFirstJoin Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public property SqlPostfix Gets the postfix statement. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public property SqlStatement Do not reference this member directly in your code. It supports the SQL Server infrastructure.

Top

Methods

  Name Description
Public method AddCondition Adds a condition which if it is true will make the result set empty. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Protected methodStatic member AddElement Adds the value to a string builder using the specified delimiters. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method AddFields Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method AddFrom Adds a classic join to the FROM clause.
Public method AddJoin Adds a new syntax join to the FROM clause
Public method AddOrderBy(String) Adds a new syntax to the ORDER BY clause
Public method AddOrderBy(String, String, OrderBy.Direction) Adds order by clause using name if the property appears in the select list if not, by value. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method AddPostfix Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method AddPrefix Adds a prefix to the statement.
Public method AddProperty Adds property to the SELECT list with specified name and value.
Public method AddUrn Adds the statement to the Unified Resource Name with the specified value. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method AddWhere Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method ClearFailCondition Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetSqlNoPrefixPostfix Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method GetType (Inherited from Object.)
Public method IsEmpty Returns a value whether the object is empty. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method MakeCopy Makes a copy of the StatementBuilder class. Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Protected method MemberwiseClone (Inherited from Object.)
Public method Merge Do not reference this member directly in your code. It supports the SQL Server infrastructure.
Public method ToString (Inherited from Object.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Sdk.Sfc Namespace