Export (0) Print
Expand All

Accessing User-Defined Types in ADO.NET 

.NET Framework 2.0

User-defined types (UDTs) are written using any of the languages supported by the .NET common language runtime (CLR) that produce verifiable code. This includes Microsoft C# and Microsoft Visual Basic. 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 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:

In This Section

Retrieving UDT Data

Describes how to retrieve UDT data and how to specify parameters.

Updating UDT Columns with DataAdapters

Describes how to work with UDTs in DataSets and how to update UDT data using DataAdapters.

See Also

Community Additions

ADD
Show:
© 2015 Microsoft