public class WebRequestDataAccess : DataAccessBase
Member | Description | |
---|---|---|
Constructor | ||
BeginTransaction | public virtual bool BeginTransaction();
|
|
CallServer | Calls the server with an XML request public XElement CallServer(XElement doc);
|
|
CloseConnection | public virtual void CloseConnection(DbCommand command);
public virtual void CloseConnection();
|
|
CommitTransaction | public virtual bool CommitTransaction();
|
|
CreateCommand | Creates a Command object and opens a connection public virtual DbCommand CreateCommand(string sql,
CommandType commandType, DbParameter[] parameters); public virtual DbCommand CreateCommand(string sql,
DbParameter[] parameters); |
|
CreateParameter | Used to create named parameters to pass to commands or the various methods of this class. public virtual DbParameter CreateParameter(string parameterName,
object value); |
|
ExecuteDataSet | Executes a SQL command against the server and returns a DataSet of the result public virtual DataSet ExecuteDataSet(string tablename,
DbCommand command, DbParameter[] parameters); public virtual DataSet ExecuteDataSet(DataSet dataSet,
string tablename, DbCommand command, DbParameter[] parameters); |
|
ExecuteNonQuery | Executes a command that doesn't return a data result. You can return output parameters and you do receive an AffectedRecords counter. public virtual int ExecuteNonQuery(DbCommand command,
DbParameter[] parameters); |
|
ExecuteReader | Executes a SQL command against the server and returns a DbDataReader public virtual DbDataReader ExecuteReader(DbCommand command,
DbParameter[] parameters); |
|
ExecuteScalar | Executes a command and returns a scalar value from it public virtual object ExecuteScalar(DbCommand command,
DbParameter[] parameters); |
|
ExecuteTable | Returns a DataTable from a Sql Command string passed in. public virtual DataTable ExecuteTable(string tableName,
DbCommand command, DbParameter[] parameters); |
|
OpenConnection | public virtual bool OpenConnection();
|
|
ParseCommandToXml | public XElement ParseCommandToXml(DbCommand command,
SqlExecutionModes executeMode); |
|
ParseConnectionString | public void ParseConnectionString();
|
|
ParseResponse | Processes the XML from the response and checks for errors If an error is found error properties are set and method returns false. public bool ParseResponse(XElement doc);
|
|
ProcessCommand | Processes a DbCommand, creates XML and sends it to the server. public XElement ProcessCommand(DbCommand command,
SqlExecutionModes sqlExecutionMode); |
|
RollbackTransaction | public virtual bool RollbackTransaction();
|
|
AffectedRecords | If calling ExecuteNonQuery returns a count of affected records | |
Command | An internal instance of a command object | |
ConnectionString | The connection string to the remote data. | |
Password | Server access username or password. This would be the HTTP password | |
ScalarResult | When calling ExecuteScalar returns a scalar result value | |
ServerUrl | The server url | |
Timeout | The timeout of requests in seconds | |
Username | Server access username or password. This would be the HTTP password |