10.16. Reading and Writing a SQL Server User-Defined Type (UDT)

Problem

You need to retrieve the value of a user-defined type that you have created using a CLR routine from a SQL Server database.

Solution

The following example creates, registers, and uses a user-defined type that defines a point—the UDT is called Point. Follow these steps:

  1. Enable CLR integration by following the instructions in the Introduction to Chapter 12, if necessary.

  2. Create a new SQL Server project in Visual Studio and name it ClrPointType. Press the Cancel button to dismiss the New Database Reference dialog that is...

Vous êtes en mode prévisualisation. Lire l'intégralité du contenu en achetant ce livre numérique