Accessing User-Defined Types in ADO.NET

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

See Also