CLR-Based User-Defined Types

With the advent of .NET integration in SQL Server 2005, you can now create CLR-based User-Defined Types (UDTs) using a .NET language of your choice. Much has been debated on the subject already since Microsoft announced their plans for strong .NET integration in the product. The whole concept of .NET (as well as XML) integration in a relational database is controversial. I must admit that I had my concerns. I thought that the worlds would collide, and that they belonged to separate universes. I was especially concerned about the large potential for abuse of these new features if they were not used wisely. In this respect, my original opinion still stands, but I believe that it’s the role of education to prevent such ...

Get Inside Microsoft® SQL Server™ 2005 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.