AbstractSqlGenerator Class

SQL generator base

Inheritance Hierarchy

System.Object
  CMS.DataEngine.AbstractSqlGenerator
    CMS.DataProviderSQL.SqlGenerator

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.2.23

Syntax

public abstract class AbstractSqlGenerator : ISqlGenerator

The AbstractSqlGenerator type exposes the following members.

Constructors

	Name	Description
Protected method	AbstractSqlGenerator

Methods

	Name	Description
Public method Static member	GetColumnList(String, String, Boolean)	Generates the column list for the SQL query.
Public method Static member	GetColumnList(String, String, Boolean, String)	Generates the column list for the SQL query.
Protected method Static member	GetCommunityMemberView	Generates the code for the Community_Member view
Public method	GetPKWhereCondition	Returns the where condition for given primary key (single or list separated by semicolon).
Public method	GetSqlQuery	Generates the given type of query for table specified by its className.
Public method	GetSystemViewSqlQuery	View name.
Protected method Static member	GetTreeJoinedBaseView	Generates the Tree_Joined view query joined on the given NodeID column
Protected method Static member	GetTreeJoinedVersionsView	Generates the code for Tree_Joined_Versions view
Protected method Static member	GetTreeJoinedView	Generates the query for the Tree_Joined view
Protected method Static member	GetUserView	Generates the code for the User view
Public method Static member	IsColumnExcluded	Returns true if the column is excluded.

Extension Methods

	Name	Description
Public Extension Method	AsValue	Converts object to a query value which can be used as a query parameter (Defined by QueryExtensions.)
Public Extension Method	GetAPIString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	GetString	Gets the string by the specified resource key (Defined by CoreExtensions.)
Public Extension Method	ToBoolean	Returns the boolean representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDateTime	Returns the DateTime representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToDouble	Returns the double representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToGuid	Returns the Guid representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToInteger	Returns the integer representation of an object or default value if not. (Defined by CoreExtensions.)
Public Extension Method	ToString	Returns the string representation of an object or default value if not. (Defined by CoreExtensions.)

Fields

	Name	Description
Protected field Static member	mExcludeColumns	Excluded columns of the document which are not included into the queries.

Properties

	Name	Description
Public property Static member	ExcludeColumns	Gets or sets the excluded columns of the document which are not included into the queries.
Public property Static member	GenerateWithExpand	Gets or sets whether With (EXPAND) should be generated in views.