Interface IDataEngine

The interface for DataEngine.


public abstract interface IDataEngine

Interface Members

MemberDescription

UpdateProgress

Raised as the data retrieval process progresses.

CreateSummaryDataForChart

Given a chart report, computes a summary that removes the detail lines from the detailed set and applies any formats to fields.

public DataTable CreateSummaryDataForChart(DataTable detailresults,
    IReport report);

CreateSummaryDataForReport

Given a report that has at least one grouped field and one aggregate field, and a detailed set of records for that report, computes a summary that removes the detail lines from the detailed set

public DataTable CreateSummaryDataForReport(DataTable detailresults,
    IReport report);

GetEmptyDataTableForReport

Given a report, returns an empty DataTable representing the columns that the real DataTable for the report would have.

public DataTable GetEmptyDataTableForReport(IReport report);

GetJoinsForReport

Given a report, return the list of joins necessary to retrieve the data for the report.

public List<IJoin> GetJoinsForReport(IReport report);

GetJoinSQLStatementForReport

Given a report, returns the "join" SQL statement for the report. Note that this returns an empty string if there is no join statement (which means that the query is not split for this report).

public string GetJoinSQLStatementForReport(IReport report);

GetNativeSQLStatementsForReport

Given a report, returns a list of the SQL statements used to retrieve the data for this report. This may be a single statement, or one for each table.

public ObservableCollection<ITableSQLStatement> GetNativeSQLStatementsForReport(IReport report);

GetValuesForField

Given a data dictionary field object, returns a list of distinct values in the database for that field. This method uses a valueconverter or values method if one is defined for the field. Otherwise, it does a SELECT DISTINCT against the database.

public IList GetValuesForField(IField field);

public IList GetValuesForField(IField field,
    IFilterCondition condition);

RetrieveDataForFields

Given a list of data dictionary field IDs, returns a DataTable containing the data for those fields as columns.

public DataTable RetrieveDataForFields(List<String> fieldIDs,
    string datasource);

RetrieveDataForFieldsWithLimit

Given a list of data dictionary field IDs, returns a DataTable containing the data for those fields as columns, up to the number of records specified for recordstoretrieve.

public DataTable RetrieveDataForFieldsWithLimit(List fieldIDs,     string datasource,     int recordstoretrieve)

RetrieveDataForLinkedReport

Retrieves the data for the specified subreport.

public DataTable RetrieveDataForLinkedReport(ILinkedReport linkedreport,
    bool cacheresults);

RetrieveDataForReport

Given a report object, returns a DataTable representing the requested data for the report.

public DataTable RetrieveDataForReport(IReport report);

RetrieveDataForSQLStatement

Retrieves the data for the specified SQL statement.

public DataTable RetrieveDataForSQLStatement(string SQLStatement,     String[] parameters,     string datasourcename)

public DataTable RetrieveDataForSQLStatement(object sql,     String[] parameters,     string datasourcename,     IDatabase database)

Error

The text of any error that occurred.

Requirements

Namespace: Stonefield.Query.DataEngine
Assembly: interfaces.dll