× {{alert.msg}} Never ask again
Get notified about new tutorials RECEIVE NEW TUTORIALS

Inserting large object into SQL Server from C#

James Jensen
May 06, 2015
<p>SQL databases aren't really optimized to store large amounts of binary data. I would recommend storing the <code>byte[]</code> contents in a form of storage that works well with large documents. For example:</p> <ul> <li>a file on a hard disk</li> <li>a cloud-based blob storage solution like AWS</li> </ul> <p>Then have your table in SQL Server store a reference (e.g. file path or AWS ID) to that document.</p> <p>This tip was originally posted on <a href="http://stackoverflow.com/questions/29951837/Inserting%20large%20object%20into%20SQL%20Server%20from%20C#/29951912">Stack Overflow</a>.</p>
comments powered by Disqus