DataTypeManager Class

Provides management of SQL data types

Inheritance Hierarchy

System.Object
  CMS.DataEngine.DataTypeManager

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0

Syntax

public class DataTypeManager

The DataTypeManager type exposes the following members.

Constructors

	Name	Description
Public method	DataTypeManager

Fields

	Name	Description
Public field Static member	CODE_VALUE_FORMAT_STRING	Represents the format string for a string value in C# code
Public field Static member	MAX_DATETIME	Minimum DateTime value for date time data type
Public field Static member	MIN_DATETIME	Minimum DateTime value for date time data type
Public field Static member	PLAIN	Represents the format string for a plain SQL value
Public field Static member	UNICODE	Represents the format string for a unicode text on SQL server

Properties

	Name	Description
Public property Static member	DataTypes	Registered data types
Public property Static member	FieldTypes	Registered data types
Public property Static member	VisibleFieldTypes	Registered data types

Methods

	Name	Description
Public method Static member	ClearRegisteredTypes	Clears the registered field types
Public method Static member	ConvertToSystemType	Converts the value to a proper data type
Public method Static member	GetDataType(Type)	Gets the data type by the system type
Public method Static member	GetDataType(TypeEnum, String)	Gets the data type settings by its SQL type
Public method Static member	GetDataTypes	Gets the data types matching the given condition
Public method Static member	GetDefaultType	Gets the default type for the given type by its system type
Public method Static member	GetFieldGroups	Gets the registered field groups
Public method Static member	GetFieldType	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 method Static member	GetFieldTypes	Returns list of all field types for the given object type
Public method Static member	GetSqlType	Gets column type for defined data type and size.
Public method Static member	GetSqlValue(Object)	Gets the value representation for a SQL query text.
Public method Static member	GetSqlValue(TypeEnum, String, Object)	Gets the value representation for a SQL query text
Public method Static member	GetStringValue	Converts the value to a string value
Public method Static member	GetSystemType	Gets the system type by the field type
Public method Static member	IsInteger	Returns true, if the given type is an integer type
Public method Static member	IsKnownType	Returns true, if the given type is a registered known type
Public method Static member	IsNumber	Returns true, if the given type is a number type
Public method Static member	IsString	Returns true, if the given type is a string type
Public method Static member	IsType<T>	Returns true, if the given type is a GUID type
Public method Static member	IsValidDate	Returns if start date of the scheduled interval is valid.
Public method Static member	RegisterDataTypes	Registers the given data type to the system
Public method Static member	SupportsTranslation	Returns true if the given field type supports translation