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

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

The AbstractSqlGenerator type exposes the following members.

Constructors
  NameDescription
Protected methodAbstractSqlGenerator
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 memberGetTreeJoinedBaseView
Generates the Tree_Joined view query joined on the given NodeID column
Protected methodStatic memberGetTreeJoinedVersionsView
Generates the code for Tree_Joined_Versions view
Protected methodStatic memberGetTreeJoinedView
Generates the query for the Tree_Joined view
Protected methodStatic memberGetUserView
Generates the code for the User view
Public methodStatic memberIsColumnExcluded
Returns true if the column is excluded.
Top
Extension Methods
  NameDescription
Public Extension MethodAsValue
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.)
Public Extension MethodGetAPIString
Gets the string by the specified resource key
(Defined by CoreExtensions.)
Public Extension MethodGetString
Gets the string by the specified resource key
(Defined by CoreExtensions.)
Public Extension MethodToBoolean
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToDateTime
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToDouble
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToGuid
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToInteger
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.)
Public Extension MethodToString
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.)
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
See Also