Элементы DataType
The DataType object represents a SQL Server data type.
Тип DataType предоставляет доступ к следующим элементам.
Конструкторы
| Имя | Описание | |
|---|---|---|
.gif "Открытый метод") |
DataType() () () () | Initializes a new instance of the DataType class. |
|
DataType(SqlDataType) | Initializes a new instance of the DataType class based on a specified SQL Server data type. |
|
DataType(UserDefinedDataType) | Initializes a new instance of the DataType class based on a specified user-defined data type. |
|
DataType(UserDefinedTableType) | Initializes a new instance of the DataType class based on a specified user-defined table type. |
|
DataType(UserDefinedType) | Initializes a new instance of the DataType class based on a specified user-defined type. |
|
DataType(XmlSchemaCollection) | Initializes a new instance of the DataType class based on a specified XML schema collection. |
|
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. |
|
DataType(SqlDataType, String) | Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type. |
|
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. |
|
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. |
В начало
Методы
| Имя | Описание | |
|---|---|---|
.gif "Статический элемент") |
Binary | Returns an object that represents the specified type. |
|
Char | Returns an object that represents the specified type. |
|
DateTime2 | 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. |
|
DateTimeOffset | 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. |
|
Decimal | Returns an object that represents the specified type. |
|
Equals(Object) | (Перезаписывает Object. . :: . .Equals(Object).) |
|
Equals(DataType) | |
.gif "Защищенный метод") |
Finalize | (Наследуется из Object.) |
|
GetHashCode | (Перезаписывает Object. . :: . .GetHashCode() () () ().) |
|
GetType | (Наследуется из Object.) |
|
MemberwiseClone | (Наследуется из Object.) |
|
NChar | Returns an object that represents the specified type. |
|
Numeric | Returns an object that represents the specified type. |
|
NVarChar | Returns an object that represents the specified type. |
|
Time | 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. |
|
ToString | Returns the object in string format. (Перезаписывает Object. . :: . .ToString() () () ().) |
|
UserDefinedDataType(String) | Returns an object that represents the specified type. |
|
UserDefinedDataType(String, String) | Returns an object that represents the specified type with the specified schema. |
|
UserDefinedTableType(String) | Returns an object that represents the specified type. |
|
UserDefinedTableType(String, String) | Returns an object that represents the specified type with the specified schema. |
|
UserDefinedType(String) | Returns an object that represents the specified type. |
|
UserDefinedType(String, String) | Returns an object that represents the specified type with the specified schema. |
|
VarBinary | Returns an object that represents the specified type. |
|
VarChar | Returns an object that represents the specified type. |
|
Xml(String) | Returns an object that represents the specified type. |
|
Xml(String, String) | Returns an object that represents the specified type and with the specified schema. |
|
Xml(String, String, XmlDocumentConstraint) | Returns an object that represents the specified type, schema and XML document constraint. |
В начало
Свойства
| Имя | Описание | |
|---|---|---|
.gif "Открытое свойство") |
BigInt | Gets a data type that specifies the BigInt definition used in the data type. |
|
Bit | Gets a data type that specifies the Bit definition used in the data type. |
|
Date | The Date property returns a Date data type. |
|
DateTime | Gets a data type that specifies the DateTime definition used in the data type. |
|
Float | Gets a data type that specifies the Float definition used in the data type. |
|
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. |
|
Geometry | The Geometry property contains spatial data that represents information about the physical location and shape of geometric objects. |
|
HierarchyId | The HierarchyId property is used to identify a position in a hierarchy. |
|
Image | Gets a data type that specifies the Image definition used in the data type. |
|
Int | Gets a data type that specifies the Int definition used in the data type. |
|
MaximumLength | Gets the maximum length of the data type. |
|
Money | Gets a data type that specifies the Money definition used in the data type. |
|
Name | Gets the name of the data type. |
|
NText | Gets a data type that specifies the NText definition used in the data type. |
|
NumericPrecision | Gets or sets the numeric precision of the data type. |
|
NumericScale | Gets or sets the numeric scale of the data type. |
|
NVarCharMax | Gets a data type that specifies the NVarCharMax definition used in the data type. |
|
Real | Gets a data type that specifies the Real definition used in the data type. |
|
Schema | Gets or sets the schema of the data type. |
|
SmallDateTime | Gets a data type that specifies the SmallDateTime definition used in the data type. |
|
SmallInt | Gets a data type that specifies the SmallInt definition used in the data type. |
|
SmallMoney | Gets a data type that specifies the SmallMoney definition used in the data type. |
|
SqlDataType | Gets a data type that specifies the SqlDataType definition used in the data type. |
|
SysName | Gets a data type that specifies the SysName definition used in the data type. |
|
Text | Gets a data type that specifies the Text definition used in the data type. |
|
Timestamp | Gets a data type that specifies the TimeStamp definition used in the data type. |
|
TinyInt | Gets a data type that specifies the TinyInt definition used in the data type. |
|
UniqueIdentifier | Gets a data type that specifies the UniqueIdentifier definition used in the data type. |
|
VarBinaryMax | Gets a data type that specifies the VarBinaryMax definition used in the data type. |
|
VarCharMax | Gets a data type that specifies the VarCharMax definition used in the data type. |
|
Variant | Gets a data type that specifies the Variant definition used in the data type. |
|
XmlDocumentConstraint | Gets or sets a value that indicates how an XML document is formatted. |
В начало