sql - How to create NVarchar(max) Sqlparameter in C#?

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/21087950/how-to-create-nvarcharmax-sqlparameter-in-c

Answer 1

This is how you explicitly set nvarchar(max):

cmd.Parameters.Add("@JobNumbers", SqlDbType.NVarChar, -1);

If you're really concerned with performance you might want to consider passing a table of integers: https://stackoverflow.com/a/10779593/465509