FILESTREAM Limitations and Considerations
From a programming standpoint, FILESTREAM offers a complete abstraction over the varbinary(max) data type. Thus, applications and frameworks (including Entity Framework) are unable to distinguish between varbinary(max) columns with the FILESTREAM attribute that are stored as files in the file system, and varbinary(max) columns without the FILESTREAM attribute that are stored inside the relational tables. This provides a high level of compatibility between FILESTREAM and existing applications that work with varbinary(max) data.
However, FILESTREAM’s internal integration with the NTFS file system does create unique challenges that affect compatibility with several other SQL Server features. It’s very important ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
