Creating SQL Server User-Defined Types with the .Net CLR

User-Defined Types (UDT) are a new feature of SQL Server 2005 (f.k.a. Yukon).  These types may be used as the type in a column or used as the type for a local variable.  Unlike standard SQL Server types, these types are created using .Net in languages such as C# and VB.Netj.

Download slides.     Download Code Samples.

SQL Server 2005 allows the creation of user-defined types using the .Net CLR.  That's right, they're written in a .Net language such as C# or Visual Basic.Net.

• Using SQL Types and .Net Types
• Working with the SQL Server managed data provider inside the type.
• Using SQL Types from client code in ADO.Net

The presentation also touches on high level topics such as:

• When is it appropriate to use .Net code versus T-SQL

Scheduled Presentations: