Attention: We are retiring the ASP.NET Community Blogs. Learn more >

UDTs in Sql Server 2005 (Yukon) and VS.NET 2005 (CLR Object)

I just wrote a user defined type in VS.NET 2005 and deployed it to Sql Server 2005.  I deployed the CLR Object to my Sql Server 2005 instance.  I was pleasantly surprised when I started to create my table which used the UDT.  When I went to the drop down to select a datatype, bang, my UDT was listed.  So cool, just the way that it is suppossed to be.  :-)

Wally

1 Comment

  • Wally,



    I am trying to do the same thing. I would really love to see my UDT in the drop down too.



    I am getting the Deploy error:



    ------ Deploy started: Project: Gender, Configuration: Debug Any CPU ------

    Deploying file: Gender.dll, Path: C:\Documents and Settings\andy.gurzynski\Local Settings\Application Data\Temporary Projects\Gender\obj\Debug\Gender.dll ...

    Error: Type 'Gender.MFType' is marked for native serialization, it is not marked with 'LayoutKind.Sequential'. Native serialization requires type to be marked with 'LayoutKind.Sequential'.

Comments have been disabled for this content.