Using Streams as Input to Long Data Parameters
Allowing the use of noncontiguous memory to represent a very large binary or text value, such as a video clip or a large document, improves performance, functionality, and scalability.
Stream objects used to read binary data are derived from the System.IO.Stream object and use the Framework data type of byte[]:
•
System.IO.BufferedStream
•
System.IO.FileStream
•
System.IO.MemoryStream
•
System.Net.Sockets.NetworkStream
•
System.Security.Cryptography.CryptoStream
Stream objects used to read text data are derived from the System.IO.TextReader object and use the Framework data type of string:
•
System.IO.StreamReader
•
System.IO.StringReader
To enable the use of streams, you set the Value property of the PsqlParameter object to a specific instance of the stream (see
PsqlParameter Object
). When the command is executed, the data provider reads from the stream to extract the value.
The examples shipped with the data provider include a code example on inserting data into LONGVARCHAR and LONGVARBINARY columns using randomly generated data. The example also shows how to use streaming objects as inputs to LONGVARCHAR and LONGVARBINARY columns.