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: 12.0.0
Syntax
C#
public static class SqlSecurityHelper

The SqlSecurityHelper type exposes the following members.

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 memberCheckQuery
Checks part of a query (or whole query) for malicious code. Returns TRUE if query contains just a SELECT statement.
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