This topic has not yet been rated - Rate this topic

Accessing User-Defined Types in ADO.NET

SQL Server 2012

User-defined types (UDTs) are written using any of the languages supported by the Microsoft .NET Framework common language runtime (CLR) that produce verifiable code. This includes Microsoft Visual 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 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.SqlDataReader as an object.
Through the SqlDataReader as raw bytes.
As a parameter of a System.Data.SqlClient.SqlParameter object.

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.

Concepts

CLR User-Defined Types

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD