Mapping T-SQL Data Types to SqlTypes

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.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.