Builds a command object that queries all records (with specified fields) from the specified table.
Defining an order is possible as well.

public virtual IDbCommand BuildAllRecordsQueryCommand( string tableName,
	string fieldList,
	string orderBy,
	DataRowProcessMethod selectMethod );

Return Value

IDbCommand object

Parameters

tableName
Name of the table to query from

fieldList
Fields to query (or * for all fields) - Note that this setting only applies if the system is NOT in Stored Procedure mode!

orderBy
Order (or empty string if no special order is desired) - Note that this setting only applies if the system is NOT in Stored Procedure mode!

selectMethod
Select method (such as stored procedure or select commands)

Remarks

Whenever this data service runs in Stored Procedure mode, it will automatically look for a Stored Procedure that matches the following naming convention:

[prefix]get[Tablename]AllRecords

For instance, if the prefix is the default prefix ("milos_"), and the table name is Customer, then the resulting stored procedure the system would use is:

milos_getCustomerAlLRecords

Note that the list of fields as well as the sort order is defined by the stored procedure, and not by the fields passed to this method.

See also:

Class SqlEverywhereDataService