AdvantageCMS.Core.Common.BaseClasses Namespace
Advantage CSP

SQL Members

The SQL type exposes the following members.

Constructors


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

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

Properties


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