SqlMetaData Constructor (String, SqlDbType, Type)

 

Initializes a new instance of the SqlMetaData class with the specified column name, type, and user-defined type (UDT).

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public SqlMetaData(
	string name,
	SqlDbType dbType,
	Type userDefinedType
)

Parameters

name
Type: System.String

The name of the column.

dbType
Type: System.Data.SqlDbType

The SQL Server type of the parameter or column.

userDefinedType
Type: System.Type

A Type instance that points to the UDT.

Exception Condition
ArgumentNullException

The Name is null.

ArgumentException

A SqlDbType that is not allowed was passed to the constructor as dbType, or userDefinedType points to a type that does not have SqlUserDefinedTypeAttribute declared.

Only the following SqlDbType is allowed to be passed to the constructor as dbType: UDT.

The following are the default values assigned to dbType, depending on the SqlDbType (the XmlSchemaCollectionDatabase, XmlSchemaCollectionName, XmlSchemaCollectionOwningSchema, and Type properties are set to null):

SqlDbType

Maximum length

Precision

Scale

Locale

Compare options

UDT

<Max length of the type> or -1

0

0

0

None

.NET Framework
Available since 2.0
Return to top
Show: