Can I use a stream to INSERT or UPDATE a row in SQL Server (C#)?

Posted by Cheeso on Stack Overflow See other posts from Stack Overflow or by Cheeso
Published on 2010-03-17T03:38:36Z Indexed on 2010/03/17 3:41 UTC
Read the original article Hit count: 231

Filed under:
|
|
|

Suppose I have a VarBinary[MAX] column, can I insert or update into that column using a type derived from System.IO.Stream? How?

I think that I can obtain a read-only stream from such a column using a SqlDataReader, calling GetSqlBytes() on the reader, getting the SqlBytes instance, and then referencing the Stream property on that.

What I want is the converse - I want a stream for update or insert.

Possible? (from c#... Without writing T-SQL ?)

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about c#