West Wind Web Toolkit for ASP.NET
Interface IDbNative
Interface IDbNative
public interface IDbNative
| Member | Description | |
|---|---|---|
 |
BeginTransaction | Begins a new transaction on this instance public bool BeginTransaction();
|
|
CloseConnection | Opens the connection on this data context public void CloseConnection();
|
|
CommitTransaction | Commits a transaction on this instance public bool CommitTransaction();
|
|
CreateCommand | Creates a new SQL Command public DbCommand CreateCommand(string sql,
DbParameter[] dbParameters); |
|
CreateParameter | Creates a new SQL Parameter public DbParameter CreateParameter(string name,
object value); public DbParameter CreateParameter(string name,
object value, ParameterDirection direction); |
|
ExecuteDataSet | Runs a query and returns a table in a DataSet either passed in or by creating a new one. public DataSet ExecuteDataSet(DbCommand sqlCommand,
DataSet dataSet, string tableName, DbParameter[] dbParameters); public DataSet ExecuteDataSet(string sql,
DataSet dataSet, string tableName, DbParameter[] dbParameters); public DataSet ExecuteDataSet(IQueryable query,
DataSet dataSet, string tableName); |
|
ExecuteDataTable | Executes a SQL command and retrieves a DataTable of the result public DataTable ExecuteDataTable(DbCommand sqlCommand,
string tableName, DbParameter[] dbParameters); public DataTable ExecuteDataTable(string sql,
string tableName, DbParameter[] dbParameters); public DataTable ExecuteDataTable(IQueryable query,
string tableName); |
|
ExecuteNonQuery | Executes a raw Sql Command against the server that doesn't return a result set. public int ExecuteNonQuery(DbCommand sqlCommand,
DbParameter[] dbParameters); public int ExecuteNonQuery(string sql,
DbParameter[] dbParameters); |
|
ExecuteReader | Returns a DbDataReader from a SQL statement. public DbDataReader ExecuteReader(DbCommand sqlCommand,
DbParameter[] dbParameters); public DbDataReader ExecuteReader(string sql,
DbParameter[] dbParameters); public DbDataReader ExecuteReader(IQueryable query);
|
|
ExecuteScalar | Executes a SQL Query and returns a single result value that isn't part of a result cursor public object ExecuteScalar(DbCommand command,
DbParameter[] dbParameters); public object ExecuteScalar(string sql,
DbParameter[] dbParameters); |
|
GetCommand | Retrieves a DbCommand from an IQueryable. public DbCommand GetCommand(IQueryable query);
|
|
OpenConnection | Opens a connection to the database public bool OpenConnection();
|
|
RollbackTransaction | Rollsback a transaction on this instance public bool RollbackTransaction();
|
 |
ErrorMessage | Error Message set on error of operations |
