Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
User-defined types (UDTs) are written using any of the languages supported by the .NET Framework common language runtime (CLR) that produce verifiable code. This includes C# and Visual Basic .NET. UDTs allow objects and custom data structures to be stored in a SQL Server database.
The data is exposed as public members of a .NET Framework class or structure, and behaviors are defined by methods of the class or structure. A UDT can be used as the column definition of a table, as a variable in a Transact-SQL batch, or as an argument of a Transact-SQL function or stored procedure.
In ADO.NET, the System.Data.SqlClient provider exposes UDTs in the following ways:
- Through the
System.Data.SqlClient.SqlDataReaderas an object. - Through the
SqlDataReaderas raw bytes. - As a parameter of a
System.Data.SqlClient.SqlParameterobject.
In this section
| Article | Description |
|---|---|
| Retrieve user-defined type (UDT) data in ADO.NET | Describes how to retrieve UDT data and how to specify parameters. |
| Update user-defined type (UDT) columns with DataAdapters | Describes how to work with UDTs in a DataSet and how to update UDT data using a DataAdapter. |