How to create NVarchar(max) Sqlparameter in C#? [duplicate]

by

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

More Related Contents:

  1. Taking lot of time to read from SQL Server using c#
  2. Automated checking of database connection and query in same database [closed]
  3. Execute non-query error [closed]
  4. Delete from two tables? [closed]
  5. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  6. Insert entire DataTable into database at once instead of row by row?
  7. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  8. Is it necessary to manually close and dispose of SqlDataReader?
  9. LINQ to SQL multiple tables left outer join
  10. DropdownList DataSource
  11. Wildcard search for LINQ
  12. Map category parent id self referencing table structure to EF Core entity
  13. SqlParameter does not allows Table name – other options without sql injection attack?
  14. Get an IDataReader from a typed List
  15. Does using parameterized SqlCommand make my program immune to SQL injection?
  16. SQL update statement in C#
  17. Any way to SQLBulkCopy “insert or update if exists”?
  18. Entity Framework – stored procedure return value
  19. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  20. Direct method from SQL command text to DataSet
  21. Table name and table field on SqlParameter C#?
  22. Get affected rows on ExecuteNonQuery
  23. Checking for empty or null JToken in a JObject
  24. Add WHERE clauses to SQL dynamically / programmatically
  25. Index (zero based) must be greater than or equal to zero
  26. When is it better to write “ad hoc sql” vs stored procedures [duplicate]
  27. Issues Doing a String Comparison in LINQ
  28. Convert SQL to LINQ Query [closed]
  29. C# SQL insert command
  30. How do I extract data from a DataTable?

Leave a Comment