SqlDbType and varchar(max) or nvarchar(max)

The short answer? Use SqlDbType.VarChar or SqlDbType.NVarChar with a size of -1. For more info, see http://msdn.microsoft.com/en-us/library/bb399384.aspx.  I just put the short answer for those who want… the short answer.