Click or drag to resize
AbstractSqlGenerator Class
SQL generator base
Inheritance Hierarchy

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0
Syntax
C#
public abstract class AbstractSqlGenerator : ISqlGenerator

The AbstractSqlGenerator type exposes the following members.

Constructors
  NameDescription
Protected methodAbstractSqlGenerator
Top
Fields
  NameDescription
Protected fieldStatic membermExcludeColumns
Excluded columns of the document which are not included into the queries.
Top
Properties
  NameDescription
Public propertyStatic memberExcludeColumns
Gets or sets the excluded columns of the document which are not included into the queries.
Public propertyStatic memberGenerateWithExpand
Gets or sets whether With (EXPAND) should be generated in views.
Top
Methods
  NameDescription
Public methodStatic memberGetColumnList(String, String, Boolean)
Generates the column list for the SQL query.
Public methodStatic memberGetColumnList(String, String, Boolean, String)
Generates the column list for the SQL query.
Protected methodStatic memberGetCommunityMemberView
Generates the code for the Community_Member view
Public methodGetPKWhereCondition
Returns the where condition for given primary key (single or list separated by semicolon).
Public methodGetSqlQuery
Generates the given type of query for table specified by its className.
Public methodGetSystemViewSqlQuery
View name.
Protected methodStatic memberGetTreeJoinedView
Generates the Tree_Joined indexed view query
Protected methodStatic memberGetUserView
Generates the code for the User view
Public methodStatic memberIsColumnExcluded
Returns true if the column is excluded.
Top
See Also