Accessing User-Defined Types in ADO.NET
Applies to: SQL Server
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.
See Also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho