Is there any where I can see a grid comparing SQL Types to system Types?

[Nick]

I need a table showing how these map to each other. Also if I use
sqltypes do I have to cast a string to a SqlString when I retrieve it
from a Web Control? I'm looking for optimal speed in our web app, and
I've read the sqltypes are faster than system types, but I'm concerned
with boxing and unboxing during type conversions. Currenly we map
strings to varchar's, datetime to sqldatetime etc. What is the faster
way?
Can anyone clarify this for me?
Much appreciated
Nick

 

[James J. Foster]

Here is a mapping table of SQL types to .NET Framework types:

http://msdn.microsoft.com/library/d.../en-us/cpref/html/frlrfsystemdatasqltypes.asp

 

[Nick]

Thanks James, I have this link bookmarked, what I'm looking for is a
table that maps say tinyInt to system.Byte, smallint to short or
Int16, varchar to String etc. We are wrestling with how to set up our
properties in the objects that we are filling from a SQL server
database.

On Thu, 3 Jul 2003 20:28:04 -0400, "James J. Foster"

Here is a mapping table of SQL types to .NET Framework types:

http://msdn.microsoft.com/library/d.../en-us/cpref/html/frlrfsystemdatasqltypes.asp