SQL Methods

The SQL type exposes the following members.

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.

SQL Methods

Methods

See Also