Namespaces

Types

Type SqlStringBuilder

Namespace NHibernate.SqlCommand

Interfaces ISqlStringBuilder

Methods

Properties

Public instance methods

SqlStringBuilder Add(SqlString sqlString, string prefix, string op, string postfix)

Adds an existing SqlString to this SqlStringBuilder
This calls the overloaded Add method with an array of SqlStrings and wrapStatment=false so it will not be wrapped with a "(" and ")"
Parameters
return SqlStringBuilder This SqlStringBuilder
SqlString sqlString The SqlString to add to this SqlStringBuilder
string prefix String to put at the beginning of the combined SqlString.
string op How these Statements should be junctioned "AND" or "OR"
string postfix String to put at the end of the combined SqlString.

SqlStringBuilder Add(SqlString sqlString)

Adds an existing SqlString to this SqlStringBuilder. It does NOT add any prefix, postfix, operator, or wrap around this. It is equivalent to just adding a string.
This calls the overloaded Add(sqlString, null, null, null, false)
Parameters
return SqlStringBuilder This SqlStringBuilder
SqlString sqlString The SqlString to add to this SqlStringBuilder

SqlStringBuilder Add(SqlString[] sqlStrings, string prefix, string op, string postfix, bool wrapStatement)

Parameters
return SqlStringBuilder
SqlString[] sqlStrings
string prefix
string op
string postfix
bool wrapStatement

SqlStringBuilder Add(SqlString[] sqlStrings, string prefix, string op, string postfix)

Parameters
return SqlStringBuilder
SqlString[] sqlStrings
string prefix
string op
string postfix

SqlStringBuilder Add(Parameter parameter)

Adds the Parameter to the SqlString that is being built. The correct operator should be added before the Add(Parameter) is called because there will be no operator ( such as "=" ) placed between the last Add call and this Add call.
Parameters
return SqlStringBuilder This SqlStringBuilder
Parameter parameter The Parameter to add.

SqlStringBuilder Add(string sql)

Adds the preformatted sql to the SqlString that is being built.
Parameters
return SqlStringBuilder This SqlStringBuilder
string sql The string to add.

SqlStringBuilder AddObject(object part)

Attempts to discover what type of object this is and calls the appropriate method.
Parameters
return SqlStringBuilder This SqlStringBuilder.
object part The part to add when it is not known if it is a Parameter, String, or SqlString.

SqlStringBuilder AddParameter()

Parameters
return SqlStringBuilder

void Clear()

bool Equals(object obj)

Parameters
return bool
object obj

int GetHashCode()

Parameters
return int

Type GetType()

Parameters
return Type

SqlStringBuilder Insert(int index, Parameter param)

Insert a Parameter into the SqlStringBuilder at the specified index.
Parameters
return SqlStringBuilder This SqlStringBuilder
int index The zero-based index at which the Parameter should be inserted.
Parameter param The Parameter to insert.

SqlStringBuilder Insert(int index, string sql)

Insert a string containing sql into the SqlStringBuilder at the specified index.
Parameters
return SqlStringBuilder This SqlStringBuilder
int index The zero-based index at which the sql should be inserted.
string sql The string containing sql to insert.

SqlStringBuilder RemoveAt(int index)

Removes the string or Parameter at the specified index.
Parameters
return SqlStringBuilder This SqlStringBuilder
int index The zero-based index of the item to remove.

SqlString ToSqlString()

Converts the mutable SqlStringBuilder into the immutable SqlString.
Parameters
return SqlString The SqlString that was built.

string ToString()

Parameters
return string

Public properties

int Count get;

Gets the number of SqlParts in this SqlStringBuilder.
return int

object Item get; set;

Gets or Sets the element at the index
return object