Home All Groups Group Topic Archive Search About

Sql 2005 and User Defined Data types

Author
12 Dec 2006 4:38 PM
Steve B.
Hi,

I've a sql 2005 db with one column of a user defined type (a custom CLR
type).

How can I deal with UDT in DataSets ?
VS throw an error when trying to design a DS with the custom type... is
there any best practice concerning udt ?

Thanks,
Steve

Author
12 Dec 2006 7:33 PM
William (Bill) Vaughn
There are a litany of issues associated with UDTs--too many to list here.
See Chapter 15. Yes, you should be able to reference UDTs from a VS-hosted
application, but you'll probably have to establish a reference to the UDT in
the project.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote
"Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
news:eC2C4vgHHHA.1816@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> I've a sql 2005 db with one column of a user defined type (a custom CLR
> type).
>
> How can I deal with UDT in DataSets ?
> VS throw an error when trying to design a DS with the custom type... is
> there any best practice concerning udt ?
>
> Thanks,
> Steve
>
Author
13 Dec 2006 8:26 AM
Steve B.
My question concerned essentially about dealing with dataset and udt.
I'm use to use strongly typed dataset and WebServices that return such
datasets. With UDT ds designer can't be used.

Steve

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> a écrit dans le
message de news: O8nfgRiHHHA.3***@TK2MSFTNGP02.phx.gbl...
Show quote
> There are a litany of issues associated with UDTs--too many to list here.
> See Chapter 15. Yes, you should be able to reference UDTs from a VS-hosted
> application, but you'll probably have to establish a reference to the UDT
> in the project.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
> news:eC2C4vgHHHA.1816@TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> I've a sql 2005 db with one column of a user defined type (a custom CLR
>> type).
>>
>> How can I deal with UDT in DataSets ?
>> VS throw an error when trying to design a DS with the custom type... is
>> there any best practice concerning udt ?
>>
>> Thanks,
>> Steve
>>
>
>
Author
13 Dec 2006 5:19 PM
William (Bill) Vaughn
Again, did you register the UDT in your project? I've been able to use UDTs
in the VS designer but not until they are registered.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote
"Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
news:%23ogfOCpHHHA.1912@TK2MSFTNGP03.phx.gbl...
> My question concerned essentially about dealing with dataset and udt.
> I'm use to use strongly typed dataset and WebServices that return such
> datasets. With UDT ds designer can't be used.
>
> Steve
>
> "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> a écrit dans le
> message de news: O8nfgRiHHHA.3***@TK2MSFTNGP02.phx.gbl...
>> There are a litany of issues associated with UDTs--too many to list here.
>> See Chapter 15. Yes, you should be able to reference UDTs from a
>> VS-hosted application, but you'll probably have to establish a reference
>> to the UDT in the project.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
>> news:eC2C4vgHHHA.1816@TK2MSFTNGP06.phx.gbl...
>>> Hi,
>>>
>>> I've a sql 2005 db with one column of a user defined type (a custom CLR
>>> type).
>>>
>>> How can I deal with UDT in DataSets ?
>>> VS throw an error when trying to design a DS with the custom type... is
>>> there any best practice concerning udt ?
>>>
>>> Thanks,
>>> Steve
>>>
>>
>>
>
>
Author
14 Dec 2006 8:38 AM
Steve B.
When I add a datatable that have one of its colum o MyType, i get this error
: "User-defined datatypes (UDTs) are not supported in the dataset designer.

Even if I add the reference to the assembly that hosts the sql type.
What did mean with "registered" in visual studio ?

Steve

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> a écrit dans le
message de news: u2VMmrtHHHA.4***@TK2MSFTNGP04.phx.gbl...
Show quote
> Again, did you register the UDT in your project? I've been able to use
> UDTs in the VS designer but not until they are registered.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
> news:%23ogfOCpHHHA.1912@TK2MSFTNGP03.phx.gbl...
>> My question concerned essentially about dealing with dataset and udt.
>> I'm use to use strongly typed dataset and WebServices that return such
>> datasets. With UDT ds designer can't be used.
>>
>> Steve
>>
>> "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> a écrit dans le
>> message de news: O8nfgRiHHHA.3***@TK2MSFTNGP02.phx.gbl...
>>> There are a litany of issues associated with UDTs--too many to list
>>> here. See Chapter 15. Yes, you should be able to reference UDTs from a
>>> VS-hosted application, but you'll probably have to establish a reference
>>> to the UDT in the project.
>>>
>>> --
>>> ____________________________________
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant
>>> Microsoft MVP
>>> INETA Speaker
>>> www.betav.com/blog/billva
>>> www.betav.com
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> __________________________________
>>> Visit www.hitchhikerguides.net to get more information on my latest
>>> book:
>>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>>> -----------------------------------------------------------------------------------------------------------------------
>>>
>>> "Steve B." <steve_beauge@com.msn_swap_msn_and_com> wrote in message
>>> news:eC2C4vgHHHA.1816@TK2MSFTNGP06.phx.gbl...
>>>> Hi,
>>>>
>>>> I've a sql 2005 db with one column of a user defined type (a custom CLR
>>>> type).
>>>>
>>>> How can I deal with UDT in DataSets ?
>>>> VS throw an error when trying to design a DS with the custom type... is
>>>> there any best practice concerning udt ?
>>>>
>>>> Thanks,
>>>> Steve
>>>>
>>>
>>>
>>
>>
>
>

AddThis Social Bookmark Button