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: 11.0.0

Syntax

public abstract class AbstractSqlGenerator : ISqlGenerator

The AbstractSqlGenerator type exposes the following members.

Constructors

	Name	Description
Protected method	AbstractSqlGenerator

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.

Methods

	Name	Description
Public method Static member	GetColumnList	Generates the column list for the SQL query.
Protected method Static member	GetCommunityFriendFriendsView	Generates the code for the View_Community_Friend_Friends view.
Protected method Static member	GetCommunityFriendRequestedFriendsView	Generates the code for the View_Community_Friend_RequestedFriends view.
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	GetTreeJoinedView	Generates the Tree_Joined indexed view query
Protected method Static member	GetUserView	Generates the code for the User view
Public method Static member	IsColumnExcluded	Returns true if the column is excluded.