eXtremeDB.SqlLocalConnection Class Reference

Local database connection for execution of SQL queries. More...

Inheritance diagram for eXtremeDB.SqlLocalConnection:

Public Member Functions
	SqlLocalConnection (Database db)
	Constructor of the database connection. Parameters db opened database More...
	SqlLocalConnection (Connection con)
	Constructor of Sql connection using existed connections Parameters con existed database connection More...
SqlResultSet	ExecuteQuery (String query, params Object[] args)
	Execute SQL query. Parameters query SQL query with '?' used as parameter placeholder. Returns cursor through selected tuples More...
int	ExecuteStatement (String stmt, params Object[] args)
	Execute SQL update statement Parameters stmt SQL DML statement with '?' used as parameter placeholder. Returns number of affected (updated, inserted, deleted) records More...
override void	StartTransaction (Database.TransactionType type, Database.TransactionPriority pri, Database.IsolationLevel level)
	Start a transaction with the specified priority and isolation level. (Nested transactions are supported.) More...
override bool	CommitTransaction ()
	Commit a transaction. More...
override void	RollbackTransaction ()
	Rollback a transaction. Note that any nested transactions are aborted. More...
override void	Disconnect ()
	Close this connection. More...
override void	Dispose ()
	Close this connection. The same as Disconnect. More...
void	DetachResultSet (SqlResultSet result)
	Internal method called by SqlResultSet. Should not be explicitly called by application. More...
IntPtr	GetEngine ()
Public Member Functions inherited from eXtremeDB.Connection
	Connection (Database db)
	Constructor of the database connection. More...
	Connection (Connection con)
	Copy constructor of the database connection. More...
	Connection (Database db, byte[] context)
	Constructor of the database connection with context. More...
void	StartTransaction (Database.TransactionType type)
	Start a transaction with the default priority and isolation level. (Nested transactions are supported.) More...
void	SetCommitPolicy (Database.CommitPolicy policy)
	Set the transaction commit policy for this connection. More...
void	DiskFlush ()
	Flush to the disk all changes made by committed transactions. This method can be used to flush changes when the MCO_COMMIT_BUFFERED transaction policy is used. More...

Properties
IDatabaseWrapper	Wrapper [get]
Properties inherited from eXtremeDB.ISqlConnection
IDatabaseWrapper	Wrapper [get]

Detailed Description

Local database connection for execution of SQL queries.

Constructor & Destructor Documentation

SqlLocalConnection() [1/2]

eXtremeDB.SqlLocalConnection.SqlLocalConnection

(

Database

db

)

Constructor of the database connection.

Parameters

db	opened database

SqlLocalConnection() [2/2]

eXtremeDB.SqlLocalConnection.SqlLocalConnection

(

Connection

con

)

Constructor of Sql connection using existed connections

Parameters

con	existed database connection

Member Function Documentation

CommitTransaction()

override bool eXtremeDB.SqlLocalConnection.CommitTransaction ( )

virtual

Commit a transaction.

Returns

false if there is an MVCC conflict.

Reimplemented from eXtremeDB.Connection.

DetachResultSet()

void eXtremeDB.SqlLocalConnection.DetachResultSet

(

SqlResultSet

result

)

Internal method called by SqlResultSet. Should not be explicitly called by application.

Implements eXtremeDB.ISqlConnection.

Disconnect()

override void eXtremeDB.SqlLocalConnection.Disconnect ( )

virtual

Close this connection.

Reimplemented from eXtremeDB.Connection.

Dispose()

override void eXtremeDB.SqlLocalConnection.Dispose ( )

virtual

Close this connection. The same as Disconnect.

Reimplemented from eXtremeDB.Connection.

ExecuteQuery()

SqlResultSet eXtremeDB.SqlLocalConnection.ExecuteQuery	(	String	query,
		params Object[]	args
	)

Execute SQL query.

Parameters

query

SQL query with '?' used as parameter placeholder.

Returns

cursor through selected tuples

Implements eXtremeDB.ISqlConnection.

ExecuteStatement()

int eXtremeDB.SqlLocalConnection.ExecuteStatement	(	String	stmt,
		params Object[]	args
	)

Execute SQL update statement

Parameters

stmt	SQL DML statement with '?' used as parameter placeholder.

Returns

number of affected (updated, inserted, deleted) records

Implements eXtremeDB.ISqlConnection.

GetEngine()

IntPtr eXtremeDB.SqlLocalConnection.GetEngine

(

)

RollbackTransaction()

override void eXtremeDB.SqlLocalConnection.RollbackTransaction ( )

virtual

Rollback a transaction. Note that any nested transactions are aborted.

Reimplemented from eXtremeDB.Connection.

StartTransaction()

override void eXtremeDB.SqlLocalConnection.StartTransaction ( Database.TransactionType  type, Database.TransactionPriority  pri, Database.IsolationLevel  level  )

virtual

Start a transaction with the specified priority and isolation level. (Nested transactions are supported.)

Reimplemented from eXtremeDB.Connection.

Property Documentation

Wrapper

IDatabaseWrapper eXtremeDB.SqlLocalConnection.Wrapper

get

---

The documentation for this class was generated from the following file:

• /home/trac/projects/eXtremeDB_8.0/supplements/netcore/src/netcore/exdbnet/SqlConnection.cs