What SqlDbType maps to varChar(max)?

Question

What SqlDbType maps to varChar(max)? SqlDbType.VarChar says that it is limited to 8K, though that may be a documentation error.

Answer 1

Use SqlDbType.Text.

VARCHAR(MAX) is actually improved TEXT from older versions of MS SQL. It differs from VARCHAR significantly.

Answer 2

Actually you can use it with VarChar. If it is a parameter you can build it with: new SqlParameter("@myparam", SqlDbType.NVarChar, -1)

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

Answer 3

Use VarChar, and set size to 2147483647 (2gb-1)