AdvantageCMS.Core.Common.BaseClasses Namespace
Build With Advantage

SQL Methods

The SQL type exposes the following members.

Methods


  Name Description
Public method ApplicationRoleSet
Applications the role set.
Public method BeginTransaction(Boolean)
Starts a new transaction.
Public method BeginTransaction()()()()
Starts a new transaction and creates a persistent connection.
Public method BlobUpdate(SQL..::..Command, String, array<Byte>[]()[][])
BLOBs the update.
Public method BlobUpdate(String, String, array<Byte>[]()[][])
BLOBs the update.
Public method CommitTransaction(Boolean)
Commits the current transaction.
Public method CommitTransaction()()()()
Commits the current transaction and terminates the persistent connection.
Public method DataSetCreate(SQL..::..Command)
Creates a DataSet.
Public method DataSetCreate(String)
Creates a DataSet.
Public method DataSetCreate(String, CommandType)
Creates a DataSet.
Public method DataSetCreate(String, array<Object>[]()[][])
Creates a DataSet.
Public method DataSetCreate(String, IDataAccessable)
Creates a DataSet using a data object.
Public method DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>))
Creates a DataSet.
Public method DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))
Creates a DataSet.
Public method DataSetCreate(SQL..::..Command, DataSet)
Creates a DataSet.
Public method DataSetCreate(String, DataSet)
Creates a DataSet.
Public method DataSetCreate(String, CommandType, DataSet)
Creates a DataSet.
Public method DataSetCreate(String, array<Object>[]()[][], DataSet)
Creates a DataSet.
Public method DataSetCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)
Creates a DataSet.
Public method DataSetCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), DataSet)
Creates a DataSet.
Public method DataTableCreate(String, String)
Creates a DataTable.
Public method DataTableCreate(SQL..::..Command, String)
Creates a DataTable.
Public method DataTableCreate(String, CommandType, String)
Creates a DataTable.
Public method DataTableCreate(String, array<Object>[]()[][], String)
Creates a DataTable.
Public method DataTableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), String)
Creates a DataTable.
Public method DataTableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), String)
Creates a DataTable.
Public method DataTableCreate(SQL..::..Command, Int32)
Creates a DataTable.
Public method DataTableCreate(String, Int32)
Creates a DataTable.
Public method DataTableCreate(String, CommandType, Int32)
Creates a DataTable.
Public method DataTableCreate(String, array<Object>[]()[][], Int32)
Creates a DataTable.
Public method DataTableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)
Creates a DataTable.
Public method DataTableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)
Creates a DataTable.
Public method DataTableCreate(SQL..::..Command)
Creates a DataTable.
Public method DataTableCreate(String)
Creates a DataTable.
Public method DataTableReaderCreate(SQL..::..Command, String)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, String)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, CommandType, String)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, array<Object>[]()[][], String)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), String)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), String)
Creates a DataTableReader.
Public method DataTableReaderCreate(SQL..::..Command, Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, CommandType, Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, array<Object>[]()[][], Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>), Int32)
Creates a DataTableReader.
Public method DataTableReaderCreate(SQL..::..Command)
Creates a DataTableReader.
Public method DataTableReaderCreate(String)
Creates a DataTableReader.
Public method Dispose()()()()
Disposes this instance.
Public method ExecuteNonQuery(SQL..::..Command)
Executes a non query against the database.
Public method ExecuteNonQuery(String)
Executes a non query against the database.
Public method ExecuteNonQuery(String, CommandType)
Executes a non query against the database.
Public method ExecuteNonQuery(String, array<Object>[]()[][])
Executes a non query against the database.
Public method ExecuteNonQuery(String, IDataAccessable)
Executes a non query against the database using a data object.
Public method ExecuteNonQuery(String, Dictionary<(Of <<'(Int32, Parameter>)>>))
Executes a non query against the database.
Public method ExecuteNonQuery(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))
Executes a non query against the database.
Public method ExecuteScalar(SQL..::..Command)
Executes a scalar query against the database.
Public method ExecuteScalar(String)
Executes a scalar query against the database.
Public method ExecuteScalar(String, CommandType)
Executes a scalar query against the database.
Public method ExecuteScalar(String, array<Object>[]()[][])
Executes a scalar query against the database.
Public method ExecuteScalar(String, IDataAccessable)
Executes a scalar query against the database using a data object.
Public method ExecuteScalar(String, Dictionary<(Of <<'(Int32, Parameter>)>>))
Executes a scalar query against the database.
Public method ExecuteScalar(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))
Executes a scalar query against the database.
Public method ExecuteXMLReader(SQL..::..Command)
Executes an XML reader query against the database.
Public method ExecuteXMLReader(String)
Executes an XML reader query against the database.
Public method HashtableCreate(SQL..::..Command)
Builds an ArrayList of HashTables from the resultset.
Public method HashtableCreate(String)
Builds an ArrayList of HashTables from the resultset.
Public method HashtableCreate(String, CommandType)
Builds an ArrayList of HashTables from the resultset.
Public method HashtableCreate(String, array<Object>[]()[][])
Builds an ArrayList of HashTables from the resultset.
Public method HashtableCreate(String, IDataAccessable)
Builds an ArrayList of HashTables from the resultset using a data object.
Public method HashtableCreate(String, Dictionary<(Of <<'(Int32, Parameter>)>>))
Builds an ArrayList of HashTables from the resultset.
Public method HashtableCreate(String, CommandType, Dictionary<(Of <<'(Int32, Parameter>)>>))
Builds an ArrayList of HashTables from the resultset.
Public method InitiatePersistentConnection
Starts a persistent connection to the datebase.
Public method RollBackTransaction(Boolean)
RollBack the current transaction
Public method RollBackTransaction()()()()
Rollback the current transaction and terminate the persistent connection.
Public method SetConnectionString
Sets the connection string.
Public method TerminatePersistentConnection
Terminates a persistent connection the database. No Transaction can be active.