DbType for user defined type (Udt)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Microsoft SQL Server
Post Reply
llorracj
Posts: 4
Joined: Mon 07 May 2012 22:18

DbType for user defined type (Udt)

Post by llorracj » Fri 30 Jan 2015 17:55

Sql Server sets DbType to Object for user defined types. The Devart provider sets it to Binary which is causing me problems. I attempt to validate the parameter value against the type and a udt validates againse Object with no problems but fails the validation against Binary.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: DbType for user defined type (Udt)

Post by Pinturiccio » Tue 03 Feb 2015 14:52

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: DbType for user defined type (Udt)

Post by Pinturiccio » Fri 13 Feb 2015 11:31

We have changed the behaviour: starting with new public version DbType property will be equal Object if SqlType property is equal Udt.

New build of dotConnect for SQL Server 2.70.1178 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/sqlser ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).

Post Reply