A list of all the SQL types and their .NET mapping?

Question

I need a list of all the SQL types and their .NET (vb would be preferred, but C# also works for me) equivalent.

Answer 1

Take a look at: http://msdn.microsoft.com/en-us/library/ms131092.aspx

Answer 2

See here: http://msdn.microsoft.com/en-us/library/4e5xt97a%28VS.71%29.aspx

Answer 3

Here's a list for .NET 3.5 / ADO.NET / SqlClient provider:

http://msdn.microsoft.com/en-us/library/cc716729.aspx

In addition, when dealing with ADO.NET parameters, keep in mind that you can specify varchar(max) or nvarchar(max) by using -1 as the length.