Hide

YetaWF.DataProvider.PostgreSQL Package Documentation

Display
Print

YetaWF.DataProvider.PostgreSQL.SQLBuilder Class

Helper class used to create dynamic SQL strings. Similar to the System.Text.StringBuilder class but specialized for SQL statements.

Namespace: YetaWF.DataProvider.PostgreSQL
Assembly: YetaWF.DataProvider.PostgreSQL

Inheritance

Syntax

public class SQLBuilder : YetaWF.DataProvider.SQLGeneric.SQLGenericBuilder;

Constructors

PublicSQLBuilderConstructor.

Fields

ProtectedInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilder_sbUsed to hold the SQL string being built.

Methods

PublicInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilderAddAppends a string.
PublicInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilderAppendAppends a string.
PublicBuildFullColumnNameReturns a formatted column name or a formatted database name, database owner, table name and column name, with brackets.
PublicBuildFullTableNameReturns a formatted table name or a formatted database name, database owner and table name, with brackets.
PublicInherited from System.ObjectEqualsDetermines whether the specified object is equal to the current object.
PublicStaticEscapeApostropheEscapes apostrophes in strings.
PublicStaticEscapeForLikeReturns a properly escaped string to be included in a LIKE statement.
ProtectedInherited from System.ObjectFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
PublicInherited from System.ObjectGetHashCodeServes as the default hash function.
PublicInherited from System.ObjectGetTypeGets the Type of the current instance.
ProtectedInherited from System.ObjectMemberwiseCloneCreates a shallow copy of the current Object.
PublicStaticInherited from System.ObjectReferenceEqualsDetermines whether the specified Object instances are the same instance.
PublicInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilderRemoveLastCharacterRemoves the last appended character from the string.
PublicInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilderRemoveLastCommaRemoves the last comma.
PublicInherited from YetaWF.DataProvider.SQLGeneric.SQLGenericBuilderToStringReturns the complete SQL string built using this instance.
PublicStaticWrapIdentifierReturns an identifier wrapped in data-provider specific delimiters.

See Also YetaWF.DataProvider.PostgreSQLYetaWF.Core