What SqlDbType maps to varBinary(max)?

by

SqlDbType.VarBinary with length -1 is the equivalent of VARBINARY(MAX), at least in theory. But the problem is a bit more complex, as there is also a type (not an enum value), namely SqlTypes.SqlBytes which can be used. And there is SqlTypes.SqlFileStream which can be used also for VARBINARY(MAX) types, when they have the FILESTREAM attribute.

But the problem is that none of these enums or types cover the real issue with working with VARBINARY(MAX) columns in ADO.Net: memory consumption. All these types, when used ‘out-of-the-box’, will create copies of the value allocated as a single array in memory, which is at best unperformant, but as content gets larger becomes down right impossible to use because allocation failures. I have a couple of articles that show the proper way to handle VARBINARY(MAX) values in ADO.Net using streaming semantics that avoid the creation of in-memory copies of the entire content:

More Related Contents:

  1. Why should I use int instead of a byte or short in C#
  2. How do I update a value in C# and SQL Server? [closed]
  3. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  4. Procedure or function xxxxx has too many arguments specified [duplicate]
  5. Call a stored procedure with parameter in c#
  6. Insert 2 million rows into SQL Server quickly
  7. SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Cannot create an automatic instance
  8. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  9. Getting data from stored procedure with Entity Framework
  10. Avoiding SQL injection without parameters
  11. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  12. Connection timeout for SQL server
  13. How can I convert ticks to a date format?
  14. Retrieve image from database in asp.net
  15. What is passing parameters to SQL and why do I need it?
  16. Fastest method for SQL Server inserts, updates, selects
  17. How to retrieve binary image from database using C# in ASP.NET
  18. Database Error: There is no row at position 0
  19. How to monitor SQL Server table changes by using c#?
  20. How to send HTML-formatted email? [duplicate]
  21. Why is ushort + ushort equal to int?
  22. SqlConnection SqlCommand SqlDataReader IDisposable
  23. SqlBulkCopy from a List
  24. How to show a image in database in the image control of Asp.net?
  25. What’s the best way to test SQL Server connection programmatically?
  26. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  27. Convert Dataset to XML
  28. Remove columns from DataTable in C#
  29. Find a control in a webform
  30. How to get the first five character of a String

Leave a Comment