Click or drag to resize
DataTypeManager Class
Provides management of SQL data types
Inheritance Hierarchy
SystemObject
  CMS.DataEngineDataTypeManager

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 10.0.0
Syntax
C#
public class DataTypeManager

The DataTypeManager type exposes the following members.

Constructors
  NameDescription
Public methodDataTypeManager
Top
Fields
  NameDescription
Public fieldStatic memberCODE_VALUE_FORMAT_STRING
Represents the format string for a string value in C# code
Public fieldStatic memberMAX_DATETIME
Minimum DateTime value for date time data type
Public fieldStatic memberMIN_DATETIME
Minimum DateTime value for date time data type
Public fieldStatic memberPLAIN
Represents the format string for a plain SQL value
Public fieldStatic memberUNICODE
Represents the format string for a unicode text on SQL server
Top
Properties
  NameDescription
Public propertyStatic memberDataTypes
Registered data types
Public propertyStatic memberFieldTypes
Registered data types
Public propertyStatic memberVisibleFieldTypes
Registered data types
Top
Methods
  NameDescription
Public methodStatic memberClearRegisteredTypes
Clears the registered field types
Public methodStatic memberConvertToSystemType
Converts the value to a proper data type
Public methodStatic memberGetDataType(Type)
Gets the data type by the system type
Public methodStatic memberGetDataType(TypeEnum, String)
Gets the data type settings by its SQL type
Public methodStatic memberGetDataTypes
Gets the data types matching the given condition
Public methodStatic memberGetDefaultType
Gets the default type for the given type by its system type
Public methodStatic memberGetFieldGroups
Gets the registered field groups
Public methodStatic memberGetFieldType
Returns form field data type from database column data type. Some sql types map to multiple field types that differ by size, e.g. nvarchar has more field data types that differ by size. Specify size to get more accurate result. By default max size for given sql type is used.
Public methodStatic memberGetFieldTypes
Returns list of all field types for the given object type
Public methodStatic memberGetSqlType
Gets column type for defined data type and size.
Public methodStatic memberGetSqlValue(Object)
Gets the value representation for a SQL query text.
Public methodStatic memberGetSqlValue(TypeEnum, String, Object)
Gets the value representation for a SQL query text
Public methodStatic memberGetStringValue
Converts the value to a string value
Public methodStatic memberGetSystemType
Gets the system type by the field type
Public methodStatic memberIsInteger
Returns true, if the given type is an integer type
Public methodStatic memberIsKnownType
Returns true, if the given type is a registered known type
Public methodStatic memberIsNumber
Returns true, if the given type is a number type
Public methodStatic memberIsString
Returns true, if the given type is a string type
Public methodStatic memberIsTypeT
Returns true, if the given type is a GUID type
Public methodStatic memberIsValidDate
Returns if start date of the scheduled interval is valid.
Public methodStatic memberRegisterDataTypes
Registers the given data type to the system
Public methodStatic memberSupportsTranslation
Returns true if the given field type supports translation
Top
See Also