C# – What size do you use for varchar(MAX) in your parameter declaration

ado.netcsql server

I normally set my column size when creating a parameter in ADO.NET.

But what size do I use if the column is of type VARCHAR(MAX)?

cmd.Parameters.Add("@blah", SqlDbType.VarChar, ?????).Value = blah;

Best Answer

In this case you use -1.