Share via

  • Article

DataType Members

Include Protected Members
Include Inherited Members

The DataType object represents a SQL Server data type.

The DataType type exposes the following members.

Constructors

  Name Description
Public method DataType() Initializes a new instance of the DataType class.
Public method DataType(SqlDataType) Initializes a new instance of the DataType class based on a specified SQL Server data type.
Public method DataType(UserDefinedDataType) Initializes a new instance of the DataType class based on a specified user-defined data type.
Public method DataType(UserDefinedTableType) Initializes a new instance of the DataType class based on a specified user-defined table type.
Public method DataType(UserDefinedType) Initializes a new instance of the DataType class based on a specified user-defined type.
Public method DataType(XmlSchemaCollection) Initializes a new instance of the DataType class based on a specified XML schema collection.
Public method DataType(SqlDataType, Int32) Initializes a new instance of the DataType class based on a specified SQL Server data type with specified precision or maximum length.
Public method DataType(SqlDataType, String) Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type.
Public method DataType(SqlDataType, Int32, Int32) Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified precision and scale.
Public method DataType(SqlDataType, String, String) Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type and schema.

Top

Methods

  Name Description
Public methodStatic member Binary(Int32) Returns an object that represents the specified type.
Public methodStatic member Char(Int32) Returns an object that represents the specified type.
Public methodStatic member DateTime2(Int32) DateTime2 is an extension of the existing DATETIME type. It has a large date range and large default fractional precision. It has a length of at least 19 positions.
Public methodStatic member DateTimeOffset(Int32) Returns values for year, month, day, valid time of day between 00:00:00 and 23:59:59:9999999 and offset, in hours, from UTC. It has a length of at least 25 positions.
Public methodStatic member Decimal(Int32, Int32) Returns an object that represents the specified type.
Public method Equals(Object) (Overrides Object.Equals(Object).)
Public method Equals(DataType)
Protected method Finalize() (Inherited from Object.)
Public method GetHashCode() (Overrides Object.GetHashCode().)
Public method GetType() (Inherited from Object.)
Protected method MemberwiseClone() (Inherited from Object.)
Public methodStatic member NChar(Int32) Returns an object that represents the specified type.
Public methodStatic member Numeric(Int32, Int32) Returns an object that represents the specified type.
Public methodStatic member NVarChar(Int32) Returns an object that represents the specified type.
Public methodStatic member Time(Int32) Returns values for any valid time of day between 00:00:00 and 23:59:59:9999999. It has a length of at least 8 positions and contains the time in hours,minutes, seconds and fractional seconds.
Public method ToString() Returns the object in string format. (Overrides Object.ToString().)
Public methodStatic member UserDefinedDataType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedDataType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member UserDefinedTableType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedTableType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member UserDefinedType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member VarBinary(Int32) Returns an object that represents the specified type.
Public methodStatic member VarChar(Int32) Returns an object that represents the specified type.
Public methodStatic member Xml(String) Returns an object that represents the specified type.
Public methodStatic member Xml(String, String) Returns an object that represents the specified type and with the specified schema.
Public methodStatic member Xml(String, String, XmlDocumentConstraint) Returns an object that represents the specified type, schema and XML document constraint.

Top

Properties

  Name Description
Public propertyStatic member BigInt Gets a data type that specifies the BigInt definition used in the data type.
Public propertyStatic member Bit Gets a data type that specifies the Bit definition used in the data type.
Public propertyStatic member Date The Date property returns a Date data type.
Public propertyStatic member DateTime Gets a data type that specifies the DateTime definition used in the data type.
Public propertyStatic member Float Gets a data type that specifies the Float definition used in the data type.
Public propertyStatic member Geography The Geography datatype represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.
Public propertyStatic member Geometry The Geometry property contains spatial data that represents information about the physical location and shape of geometric objects.
Public propertyStatic member HierarchyId The HierarchyId property is used to identify a position in a hierarchy.
Public propertyStatic member Image Gets a data type that specifies the Image definition used in the data type.
Public propertyStatic member Int Gets a data type that specifies the Int definition used in the data type.
Public property MaximumLength Gets the maximum length of the data type.
Public propertyStatic member Money Gets a data type that specifies the Money definition used in the data type.
Public property Name Gets the name of the data type.
Public propertyStatic member NText Gets a data type that specifies the NText definition used in the data type.
Public property NumericPrecision Gets or sets the numeric precision of the data type.
Public property NumericScale Gets or sets the numeric scale of the data type.
Public propertyStatic member NVarCharMax Gets a data type that specifies the NVarCharMax definition used in the data type.
Public propertyStatic member Real Gets a data type that specifies the Real definition used in the data type.
Public property Schema Gets or sets the schema of the data type.
Public propertyStatic member SmallDateTime Gets a data type that specifies the SmallDateTime definition used in the data type.
Public propertyStatic member SmallInt Gets a data type that specifies the SmallInt definition used in the data type.
Public propertyStatic member SmallMoney Gets a data type that specifies the SmallMoney definition used in the data type.
Public property SqlDataType Gets a data type that specifies the SqlDataType definition used in the data type.
Public propertyStatic member SysName Gets a data type that specifies the SysName definition used in the data type.
Public propertyStatic member Text Gets a data type that specifies the Text definition used in the data type.
Public propertyStatic member Timestamp Gets a data type that specifies the TimeStamp definition used in the data type.
Public propertyStatic member TinyInt Gets a data type that specifies the TinyInt definition used in the data type.
Public propertyStatic member UniqueIdentifier Gets a data type that specifies the UniqueIdentifier definition used in the data type.
Public propertyStatic member VarBinaryMax Gets a data type that specifies the VarBinaryMax definition used in the data type.
Public propertyStatic member VarCharMax Gets a data type that specifies the VarCharMax definition used in the data type.
Public propertyStatic member Variant Gets a data type that specifies the Variant definition used in the data type.
Public property XmlDocumentConstraint Gets or sets a value that indicates how an XML document is formatted.

Top