dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlBlob Class / Length Property
Example

In This Topic
    Length Property (PgSqlBlob)
    In This Topic
    Gets the size of the PgSqlBlob.
    Syntax
    'Declaration
     
    Public Overrides ReadOnly Property Length As Long
    public override long Length {get;}

    Property Value

    The size of the PgSqlBlob in bytes.
    Remarks
    The size of the PgSqlBlob is always returned in bytes for all data types.
    Example
    PgSqlDataReader pictureReader = myCommand.ExecuteReader();
    pictureReader.Read();
    PgSqlBlob pictureBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"));
    if (pictureBlob.Length > 100)
      pictureBlob.SetLength(100);
    Dim pictureReader As PgSqlDataReader = myCommand.ExecuteReader
    pictureReader.Read()
    Dim pictureBlob As PgSqlBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"))
    If (pictureBlob.Length > 100) Then
      pictureBlob.SetLength(CLng(100))
    End If
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also