I'm having some trouble with using FILESTREAM columns in SQL Server with Data Access. This is the error I'm getting:
Telerik.OpenAccess.RT.sql.SQLException: Partial updates are not supported on columns that have a FILESTREAM as a source.
Statement(s) could not be prepared. ---> System.Data.SqlClient.SqlException: Partial updates are not supported on columns that have a FILESTREAM as a source.
Statement(s) could not be prepared.
Are FILESTREAM columns supported at all by Data Access when using BinaryStream? I'm not doing anything that I would expect to cause a partial update. Here is my SQL and an adapted version of my C#:
Blob blob =
), 0, 13);
The error happens on the last line.