Can I use a stream to INSERT or UPDATE a row in SQL Server (C#)?
- by Cheeso
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 ?)