AdvantageCMS.Core.Common.BaseClasses Namespace
Build With Advantage

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)
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.

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 legacy 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].