FetchAll Property (PgSqlCursor)

In This Topic

Gets or sets a value indicating whether the PgSqlDataReader object will request data from the server on execution ExecuteReader method.

Syntax

Visual Basic
C#

'Declaration
 
Public Property FetchAll As Boolean

public bool FetchAll {get; set;}

Property Value

true, if the PgSqlDataReader object will request data from the server on execution ExecuteReader; otherwise false. The default value is true.

Remarks

FetchAll property allows your application to reduce greatly size of used memory on processing big volume data. If set to true, memory will be allocated for all data returned by your SELECT. If FetchAll property is set to false, memory will be allocated only at most for hundred records and on retrieving next records previous rows will be rewritten.

Reference

PgSqlCursor Class
PgSqlCursor Members

Send Feedback