StatementBuilder Class

Definition

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
StatementBuilder
Attributes

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)

add to the ORDER BY 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

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

Applies to