StrataFrame Forum

Issue with TinyInt

http://forum.strataframe.net/Topic11220.aspx

By Tim Dol - 8/29/2007

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

By Greg McGuffey - 8/29/2007

This is correct.



http://msdn2.microsoft.com/en-us/library/ms131092.aspx
By StrataFrame Team - 8/30/2007

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.
By StrataFrame Team - 8/30/2007

Good link Greg.  There's a lot of good info in SQL Server Books Online.