Data Service for SQL Server Everywhere Edition databases

System.Object
  EPS.Data.DataService
    EPS.Data.SqlEverywhere.SqlEverywhereDataService

public class SqlEverywhereDataService : DataService

Class Members

Member	Description
Constructor
AbortTransaction	Aborts a transaction and reverts all changes in the database public virtual bool AbortTransaction();
ApplyAppRole	This method is not supported on this service public virtual bool ApplyAppRole( string role, string password );
BeginTransaction	Begins a transaction using default SQL transaction logic. public virtual bool BeginTransaction();
BuildAllRecordsQueryCommand	Builds a command object that queries all records (with specified fields) from the specified table. public virtual IDbCommand BuildAllRecordsQueryCommand( string tableName, string fieldList, string orderBy, DataRowProcessMethod selectMethod );
BuildDeleteCommand	Creates a delete command object for the defined table and primary key. public virtual IDbCommand BuildDeleteCommand( string tableName, string primaryKeyFieldName, object primaryKeyValue, DataRowProcessMethod updateMethod );
BuildEmptyRecordQueryCommand	Builds a command object that queries an empty record containing all fields of the specified table. public virtual IDbCommand BuildEmptyRecordQueryCommand( string tableName, string fieldList, DataRowProcessMethod selectMethod );
BuildSingleRecordQueryCommand	Returns a single record (with a specified list of fields) by primary key. public virtual IDbCommand BuildSingleRecordQueryCommand( string tableName, string fieldList, string primaryKeyFieldName, object primaryKeyValue, DataRowProcessMethod selectMethod );
BuildUpdateCommand	Creates an update command object for the row passed along. public virtual IDbCommand BuildUpdateCommand( DataRow changedRow, KeyType primaryKeyType, string primaryKeyFieldName, DataRowUpdateMode updateMode, DataRowProcessMethod updateMethod );
CommitTransaction	Commits a transaction (commits changes to the database) public virtual bool CommitTransaction();
ExecuteNonQuery	Executes an Sql Everywhere Command and returns the number of affected rows. public virtual int ExecuteNonQuery( IDbCommand command );
ExecuteQuery	Executes a query against SQL Server Everywhere Edition public virtual DataSet ExecuteQuery( IDbCommand command, string entityName, DataSet existingDataSet ); public virtual DataSet ExecuteQuery( IDbCommand command, string entityName );
ExecuteScalar	Executes an Sql Everywhere Command and returns a single value public virtual object ExecuteScalar( IDbCommand command );
ExecuteStoredProcedure	Executes a stored procedure public virtual bool ExecuteStoredProcedure( IDbCommand command );
ExecuteStoredProcedureQuery	Executes a stored procedure and adds the result to an existing DataSet public virtual DataSet ExecuteStoredProcedureQuery( IDbCommand command, string entityName, DataSet existingDataSet ); public virtual DataSet ExecuteStoredProcedureQuery( IDbCommand command, string entityName );
GetCommandParameterValue	Generically returns the value of the specified parameter in a SqlCommand object. public virtual object GetCommandParameterValue( string parameterName, IDbCommand command );
IsValid	Returns true if the current service is valid and can thus access data. public virtual bool IsValid();
NewCommandObject	Returns a new SqlEverywhereCommand object. public virtual IDbCommand NewCommandObject();
NewCommandObjectParameter	Returns an instance of a parameter object that can be added public virtual IDbDataParameter NewCommandObjectParameter( string parameterName, object parameterValue );
RevertAppRole	This method is not supported on this service public virtual bool RevertAppRole();
ConnectionStatus	Type of connection.
LastError	Last error message encountered by this service
MinimumCommandTimeout	Minimum command timeout

Requirements

Namespace: EPS.Data.SqlEverywhere
Assembly: SQLEVERYWHEREDATASERVICE.DLL