dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlCursor Class / FetchAll Property

In This Topic
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
'Declaration
 
Public Property FetchAll As Boolean
 

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.
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

Reference

PgSqlCursor Class
PgSqlCursor Members

 

 

© 2003 - 2025 Devart. All Rights Reserved.

Send Feedback