In the long list of data types that the SqlClient.SqlTypes namespace exposes, you find lots of familiar data types to choose from. But which of these data types match the T-SQL data types you use in your server-side procedures?

Main article: Beyond T-SQL: Digging into the CLR

I've been told that the most recent builds of Visual Studio 2005 and SQL Server 2005 are more tolerant of native (as opposed to SqlTypes) data types.