West Wind Web Toolkit for ASP.NET
Class SqlNative
Class SqlNative
public class SqlNative : object, IDbNative
| Member | Description | |
|---|---|---|
 |
Constructor | |
  |
DbProvider | Internal Provider factory for native commands |
 |
BeginTransaction | Starts a new transaction on this connection/instance. public sealed bool BeginTransaction();
|
|
CloseConnection | Opens the connection on this data context public sealed void CloseConnection();
|
|
CommitTransaction | Commits all changes to the database and ends the transaction public sealed bool CommitTransaction();
|
|
CreateCommand | Creates a new SQL Command public sealed DbCommand CreateCommand(string sql,
DbParameter[] dbParameters); |
|
CreateCommandWithValues | Pass positional parameters public DbCommand CreateCommandWithValues(string sql,
Object[] parameters); |
|
CreateParameter | Creates a new SQL Parameter public sealed DbParameter CreateParameter(string name,
object value, ParameterDirection direction); public sealed DbParameter CreateParameter(string name,
object value); |
|
ExecuteDataSet | Runs a query and returns a table in a DataSet either passed in or by creating a new one. public sealed DataSet ExecuteDataSet(DbCommand sqlCommand,
DataSet dataSet, string tableName, DbParameter[] dbParameters); public sealed DataSet ExecuteDataSet(string sql,
DataSet dataSet, string tableName, DbParameter[] dbParameters); public sealed DataSet ExecuteDataSet(IQueryable query,
DataSet dataSet, string tableName); |
|
ExecuteDataTable | Executes a SQL command and retrieves a DataTable of the result public sealed DataTable ExecuteDataTable(DbCommand sqlCommand,
string tableName, DbParameter[] dbParameters); public sealed DataTable ExecuteDataTable(string sql,
string tableName, DbParameter[] dbParameters); public sealed DataTable ExecuteDataTable(IQueryable query,
string tableName); |
|
ExecuteNonQuery | Executes a raw Sql Command against the server that doesn't return a result set. public sealed int ExecuteNonQuery(DbCommand sqlCommand,
DbParameter[] dbParameters); public sealed int ExecuteNonQuery(string sql,
DbParameter[] dbParameters); |
|
ExecuteReader | Returns a DbDataReader from a SQL statement. public sealed DbDataReader ExecuteReader(DbCommand sqlCommand,
DbParameter[] dbParameters); public sealed DbDataReader ExecuteReader(string sql,
DbParameter[] dbParameters); public sealed DbDataReader ExecuteReader(IQueryable query);
|
|
ExecuteScalar | Executes a SQL Query and returns a single result value that isn't part of a result cursor public virtual object ExecuteScalar(DbCommand command,
DbParameter[] dbParameters); public sealed object ExecuteScalar(string sql,
DbParameter[] dbParameters); |
|
GetCommand | Retrieves a DbCommand from an IQueryable. public sealed DbCommand GetCommand(IQueryable query);
|
|
OpenConnection | Opens a connection to the database public sealed bool OpenConnection();
|
|
RollbackTransaction | Rolls back a transaction public sealed bool RollbackTransaction();
|
 |
Connection | Active Connection if any |
|
ErrorMessage | Error Message if an error occurs |
|
Transaction | Active Transaction if any |
