Handle Images and Video in C# EF 6 -> Recommended maximum file size

c# entity-framework entity-framework-6

Popular Answer

There isn't really a means to choose your maximum that is objective.

SQL only provisions what is needed by your data anyway so if you have usedvarbinary(max) The fact that the field has a 2GB capacity doesn't matter since it will only be used for 200MB of the 200MB video file you are inserting for your column data type.

Given that, unless you are certain of the precise size of each file, I would advise using varbinary(max). In this manner, you can be certain that there will be room for it and that your data won't be truncated to fit.

0
6/14/2017 10:20:38 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow