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.
	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)	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, array<Object>[]()[][])	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, IDataAccessable)	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(SQL..::..Command, DataSet)	Creates a DataSet.
	DataSetCreate(String, DataSet)	Creates a DataSet.
	DataSetCreate(String, CommandType, DataSet)	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, array<Object>[]()[][], DataSet)	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)	Builds an ArrayList of HashTables from the resultset.
	DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)	Builds an ArrayList of HashTables from the resultset.
	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.
	ExecuteNonQuery(SQL..::..Command)	Executes a non query against the database.
	ExecuteNonQuery(String)	Executes a non query against the database.
	ExecuteNonQuery(String, CommandType)	Builds an ArrayList of HashTables from the resultset.
	ExecuteNonQuery(String, array<Object>[]()[][])	Builds an ArrayList of HashTables from the resultset.
	ExecuteNonQuery(String, IDataAccessable)	Builds an ArrayList of HashTables from the resultset.
	ExecuteNonQuery(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	ExecuteNonQuery(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	ExecuteScalar(SQL..::..Command)	Executes a scalar query against the database.
	ExecuteScalar(String)	Executes a scalar query against the database.
	ExecuteScalar(String, CommandType)	Builds an ArrayList of HashTables from the resultset.
	ExecuteScalar(String, array<Object>[]()[][])	Builds an ArrayList of HashTables from the resultset.
	ExecuteScalar(String, IDataAccessable)	Builds an ArrayList of HashTables from the resultset.
	ExecuteScalar(String, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	ExecuteScalar(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))	Builds an ArrayList of HashTables from the resultset.
	ExecuteXMLReader(SQL..::..Command)	Executes a scalar query against the database.
	ExecuteXMLReader(String)	Executes a scalar query against the database.
	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.
	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