dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnectionStringBuilder Class / DefaultFetchSize Property

In This Topic
    DefaultFetchSize Property
    In This Topic
    Gets or sets the default value of the OracleCommand.FetchSize property of OracleCommand instances, created via the CreateCommand method.
    Syntax
    'Declaration
     
    Public Property DefaultFetchSize As Integer
    public int DefaultFetchSize {get; set;}

    Property Value

    The default value of the OracleCommand.FetchSize property of OracleCommand instances, created via the CreateCommand method.
    Remarks

    This property allows you to set the default number of rows that will be transferred across the network at a time for all OracleCommand instances, created via the CreateCommand method.

    If you don't specify this connection string parameter, OracleCommand instances will have OracleCommand.FetchSize set to 0, which means that the number of rows to fetch at a time will be determined automatically and it will be changed dynamically when executing read operations.

    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