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

2 posts, 1 answers
  1. Kendall
    Kendall avatar
    1 posts
    Member since:
    Nov 2015

    Posted 12 Nov 2015 Link to this post

    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.

  2. Answer
    Kristian Nikolov
    Admin
    Kristian Nikolov avatar
    206 posts

    Posted 17 Nov 2015 Link to this post

    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
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  3. DevCraft banner
Back to Top