Close Method (PgSqlBlob)

In This Topic

Closes the current stream and releases any resources associated with it.

Syntax

Visual Basic
C#


'Declaration Public Overrides Sub Close()


public override void Close()

Remarks

Use Close to free resources taken by a PgSqlBlob instance, i.e. after performing large data transfer. After closing PgSqlBlob object call of any method of this object will throw an System.ObjectDisposedException.

This method is actually the same as Dispose() method.

Example

csharp


PgSqlDataReader pictureReader = myCommand.ExecuteReader(); pictureReader.Read(); PgSqlBlob pictureBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture")); ... //use pictureBlob ... pictureBlob.Close();

PgSqlDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
PgSqlBlob pictureBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"));
...
//use pictureBlob
...
pictureBlob.Close();

Visual Basic


Dim pictureReader As PgSqlDataReader = myCommand.ExecuteReader pictureReader.Read() Dim pictureBlob As PgSqlBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture")) ... 'use pictureBlob ... pictureBlob.Close()

Dim pictureReader As PgSqlDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As PgSqlBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"))
...
'use pictureBlob
...
pictureBlob.Close()

Reference

PgSqlBlob Class
PgSqlBlob Members

Send Feedback