Issue with TinyInt
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Issue with TinyIntExpand / Collapse
Author
Message
Posted 08/29/2007 12:24:18 PM
StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: 06/25/2008 11:53:33 AM
Posts: 306, Visits: 1,216
I have set the data types for a number of fields to 'TinyInt'. These values come accross as System.Byte in the mapper. Is this correct or a small bug?


Tim

Post #11220
Posted 08/29/2007 5:25:06 PM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:28:28 PM
Posts: 1,148, Visits: 2,830
This is correct.

http://msdn2.microsoft.com/en-us/library/ms131092.aspx
Post #11227
Posted 08/30/2007 9:12:33 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863
Yep, it's correct, in fact, we had to put some special clase code in the BOMapper to make it map like that.  According to the GetScema() method of SqlCommand that tells the native .NET type that is supposed to support a column, it says it should be System.SByte, but that's a "signed byte" (-128 to 127) and doesn't work with tiny int which should be 0 to 255.


www.bungie.net
Post #11232
Posted 08/30/2007 9:13:24 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863
Good link Greg.  There's a lot of good info in SQL Server Books Online.


www.bungie.net
Post #11233
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 3:58pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 12 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.