SQL Members

The SQL type exposes the following members.

Constructors

	Name	Description
	SQL()()()()	Initializes a new instance of the SQL class.
	SQL(Int32)	Initializes a new instance of the SQL class.
	SQL(String)	Initializes a new instance of the SQL class.

Methods

	Name	Description
	ApplicationRoleSet	Applications the role set.
	BeginTransaction(Boolean)	Starts a new transaction.
	BeginTransaction()()()()	Starts a new transaction and creates a persistent connection.
	BlobUpdate(SQL..::..Command, String, array<Byte>[]()[][])	BLOBs the update.
	BlobUpdate(String, String, array<Byte>[]()[][])	BLOBs the update.
	ClearParameterCache	Empties the process-wide stored-procedure parameter cache. The cache is static and shared across the AppDomain, so this affects every SQL instance. Intended for callers that need a guaranteed fresh parameter discovery — for example new-site initialization, which runs the first discovery against a brand-new database whose connection pools were just cleared.
	CommitTransaction(Boolean)	Commits the current transaction.
	CommitTransaction()()()()	Commits the current transaction and terminates the persistent connection.
	DataSetCreate(SQL..::..Command)	Creates a DataSet.
	DataSetCreate(String)	Creates a DataSet.
	DataSetCreate(String, CommandType)	Creates a DataSet.
	DataSetCreate(String, array<Object>[]()[][])	Creates a DataSet.
	DataSetCreate(String, IDataAccessable)	Creates a DataSet using a data object.
	DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Creates a DataSet.
	DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Creates a DataSet.
	DataSetCreate(SQL..::..Command, DataSet)	Creates a DataSet.
	DataSetCreate(String, DataSet)	Creates a DataSet.
	DataSetCreate(String, CommandType, DataSet)	Creates a DataSet.
	DataSetCreate(String, array<Object>[]()[][], DataSet)	Creates a DataSet.
	DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)	Creates a DataSet.
	DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)	Creates a DataSet.
	DataTableCreate(String, String)	Creates a DataTable.
	DataTableCreate(SQL..::..Command, String)	Creates a DataTable.
	DataTableCreate(String, CommandType, String)	Creates a DataTable.
	DataTableCreate(String, array<Object>[]()[][], String)	Creates a DataTable.
	DataTableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), String)	Creates a DataTable.
	DataTableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), String)	Creates a DataTable.
	DataTableCreate(SQL..::..Command, Int32)	Creates a DataTable.
	DataTableCreate(String, Int32)	Creates a DataTable.
	DataTableCreate(String, CommandType, Int32)	Creates a DataTable.
	DataTableCreate(String, array<Object>[]()[][], Int32)	Creates a DataTable.
	DataTableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)	Creates a DataTable.
	DataTableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)	Creates a DataTable.
	DataTableCreate(SQL..::..Command)	Creates a DataTable.
	DataTableCreate(String)	Creates a DataTable.
	DataTableReaderCreate(SQL..::..Command, String)	Creates a DataTableReader.
	DataTableReaderCreate(String, String)	Creates a DataTableReader.
	DataTableReaderCreate(String, CommandType, String)	Creates a DataTableReader.
	DataTableReaderCreate(String, array<Object>[]()[][], String)	Creates a DataTableReader.
	DataTableReaderCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), String)	Creates a DataTableReader.
	DataTableReaderCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), String)	Creates a DataTableReader.
	DataTableReaderCreate(SQL..::..Command, Int32)	Creates a DataTableReader.
	DataTableReaderCreate(String, Int32)	Creates a DataTableReader.
	DataTableReaderCreate(String, CommandType, Int32)	Creates a DataTableReader.
	DataTableReaderCreate(String, array<Object>[]()[][], Int32)	Creates a DataTableReader.
	DataTableReaderCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)	Creates a DataTableReader.
	DataTableReaderCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)	Creates a DataTableReader.
	DataTableReaderCreate(SQL..::..Command)	Creates a DataTableReader.
	DataTableReaderCreate(String)	Creates a DataTableReader.
	Dispose()()()()	Disposes this instance.
	Dispose(Boolean)	Releases unmanaged and - optionally - managed resources.
	ExecuteNonQuery(SQL..::..Command)	Executes a non query against the database.
	ExecuteNonQuery(String)	Executes a non query against the database.
	ExecuteNonQuery(String, CommandType)	Executes a non query against the database.
	ExecuteNonQuery(String, array<Object>[]()[][])	Executes a non query against the database.
	ExecuteNonQuery(String, IDataAccessable)	Executes a non query against the database using a data object.
	ExecuteNonQuery(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Executes a non query against the database.
	ExecuteNonQuery(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Executes a non query against the database.
	ExecuteScalar(SQL..::..Command)	Executes a scalar query against the database.
	ExecuteScalar(String)	Executes a scalar query against the database.
	ExecuteScalar(String, CommandType)	Executes a scalar query against the database.
	ExecuteScalar(String, array<Object>[]()[][])	Executes a scalar query against the database.
	ExecuteScalar(String, IDataAccessable)	Executes a scalar query against the database using a data object.
	ExecuteScalar(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Executes a scalar query against the database.
	ExecuteScalar(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Executes a scalar query against the database.
	ExecuteXMLReader(SQL..::..Command)	Executes an XML reader query against the database.
	ExecuteXMLReader(String)	Executes an XML reader query against the database.
	GetConnectionString	Gets the connection string from the config file. Resolves the connection string for this SQL instance, using this lookup order: The explicit value previously set via SetConnectionString(String). The per-thread ambient pushed via Scope(String), if any. ConfigurationManager.ConnectionStrings[_ConnectionID] if a ConnectionID was supplied to the constructor. ConfigurationManager.AppSettings["DefaultConnection"] resolved against ConnectionStrings. The first entry in ConfigurationManager.ConnectionStrings as a last-resort fallback. The ambient (step 2) is checked BEFORE any ConfigurationManager lookup so callers running inside a Scope(String) bypass web.config entirely — used by the InitializeCSP wizard's Step 5 to build the first domain before web.config is written.
	GetResultSets	Iterates through a data reader and returns the result sets.
	HashtableCreate(SQL..::..Command)	Builds an ArrayList of HashTables from the resultset.
	HashtableCreate(String)	Builds an ArrayList of HashTables from the resultset.
	HashtableCreate(String, CommandType)	Builds an ArrayList of HashTables from the resultset.
	HashtableCreate(String, array<Object>[]()[][])	Builds an ArrayList of HashTables from the resultset.
	HashtableCreate(String, IDataAccessable)	Builds an ArrayList of HashTables from the resultset using a data object.
	HashtableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	HashtableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	InitiatePersistentConnection	Starts a persistent connection to the datebase.
	RollBackTransaction(Boolean)	RollBack the current transaction
	RollBackTransaction()()()()	Rollback the current transaction and terminate the persistent connection.
	SetConnectionString	Sets the connection string.
	TerminatePersistentConnection	Terminates a persistent connection the database. No Transaction can be active.

Properties

	Name	Description
	CommandTimeout	Gets or sets the command timeout.
	ConnectionID	The connection add from the config file.
	ForceCommandType	To overcome bad legacy code we will allow user to set the command type on a single command
	HideException	Gets or sets a value indicating whether [hide exception].
	IsPersistentConnection	Gets a value indicating whether this instance is persistent connection.
	IsTransaction	Gets a value indicating whether this instance is transaction.
	LastException	Gets or sets the last exception.
	UseDefaultReturnParameter	Gets or sets a value indicating whether [use default return parameter].

SQL Members

Constructors

Methods

Properties

See Also