What are SQL Server data-types mapped to by default in ADO.NET?

Question

I need a list of all the SQL types and their .NET equivalent.

Answer 1

See this post, for SQL Server types.

For other data providers see this.

Answer 2

Take a look at: http://msdn.microsoft.com/en-us/library/ms131092.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.