Click or drag to resize
SqlSecurityHelper Class
Security methods for SQL queries
Inheritance Hierarchy
SystemObject
  CMS.DataEngineSqlSecurityHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0
Syntax
C#
public static class SqlSecurityHelper

The SqlSecurityHelper type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberSQLIdentifier
SQL identifier
Public fieldStatic memberSQLNumber
SQL number
Public fieldStatic memberSQLString
SQL string
Top
Properties
  NameDescription
Public propertyStatic memberColumnsRegex
Regular expression to check security of COLUMNS clause.
Public propertyStatic memberOrderByRegex
Regular expression to check security of ORDER BY clause.
Public propertyStatic memberWhereRegex
Regular expression to check security of WHERE clause.
Top
Methods
  NameDescription
Public methodStatic memberGetColumnsRegEx
Gets the regular expression for the safe value of COLUMNS clause.
Public methodStatic memberGetOrderByRegEx
Gets the regular expression for the safe value of ORDER BY clause.
Public methodStatic memberGetWhereRegEx
Gets the regular expression for the safe value of WHERE condition.
Top
See Also