Partial updates are not supported on columns that have a FILESTREAM as a source.

[Kendall]

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#:

SQL:

[BinaryData] varbinary(max) FILESTREAM

C#:

Blob blob = new Blob();
context.Add(blob);
context.SaveChanges();
blob.BinaryData.Write(Encoding.ASCII.GetBytes("Hello, World!"), 0, 13);
context.SaveChanges();

The error happens on the last line.

[Kristian Nikolov]

Hello Kendall,

Thank you for contacting us.

While Telerik DataAccess does support binary columns, FileStream columns in particular are not currently supported. We have this missing functionality logged in our system, but we are unable to provide you with any time frame as to when it would be addressed.

I hope this helps. Feel free to get back to us in case you have further questions.

Regards,
Kristian Nikolov
Telerik