With the MaxRows property you set the maximum number of rows that will be loaded into the resultset for the recordset.


By default the value is set to 500 rows (records).


If a recordset contains multiple resultsets, the limit counts for each of the resultsets.


Also see the MaxRows defaults to 500 document.


This property is defined in the generated recordset code.


public int MaxRows { get; set; }


Examples


customers.MaxRows = 100;

customers.ExecSql();