Click or drag to resize

ExecSQLArgsData Property

If a DataTable is provided, it will be used by the mapper instead of performing the query. The structure for the DataTable can be obtained from the mapper by calling Exec(MapperExecCmds, Int32, Object) with the RetrieveDataTable command. Note that currently the returned data is used only for the Aggregate statement and is ignored for all other statement types.

Only the mapper's aggregate data can be provided during the MapperExecSQL event. To provide the primary data, set Data during the MapperBeforeRequery event.

Namespace:  NetQuarry.Data
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
Copy
public DataTable Data { get; set; }

Property Value

Type: DataTable
Remarks
In most cases the data types expected by the mapper are the same for a particular field's operational data and its aggregate value. However, for certain aggregate types, for example Range and AvgAndSum, the aggregate data type will be a string and therefore differ from the original data type. In cases where such aggregate types are specified you cannot, at present, use RetrieveDataTable to create the DataTable structure as it will be incorrect for the fields with those aggregate types.
See Also