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

This is correct.



http://msdn2.microsoft.com/en-us/library/ms131092.aspx

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.

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