Length Property (SQLiteBlob)

In This Topic

Gets the size of the SQLiteBlob.

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides ReadOnly Property Length As Long

public override long Length {get;}

Property Value

The size of the SQLiteBlob in bytes.

Remarks

The size of the SQLiteBlob is always returned in bytes for all data types.

Example

csharp

SQLiteDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
SQLiteBlob pictureBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);

Visual Basic

Dim pictureReader As SQLiteDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As SQLiteBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If

Reference

SQLiteBlob Class
SQLiteBlob Members
SetLength Method

Send Feedback