Energy.Source.Connection< T > Class Template Reference

Generic method with type of SQL connection driver class More...

Inheritance diagram for Energy.Source.Connection< T >:

Public Member Functions
	Connection ()
	Connection (string connectionString)
	Connection ()
	Connection (Type vendor)
	Connection (Type vendor, string connectionString)
	Connection (Type vendor, Configuration configuration)
	Connection (IDbConnection connection)
string	GetErrorText ()
	Get error text More...
IDbConnection	Create ()
	Create connection object of vendor class More...
IDbConnection	Open (IDbConnection connection)
IDbConnection	Open ()
void	Close ()
	Close existing connection More...
bool	Test ()
	Test database connection More...
Energy.Base.Table	Fetch (string query)
	Fetch query results into Energy.Base.Table More...
DataTable	Load (string query)
	Load data from query into DataTable More...
DataTable	Read (string query)
	Read query results into DataTable. More...
IDbCommand	Prepare (IDbConnection connection, string query)
int	Execute (string query)
string	Parse (string query)
string	Parse (string query, Energy.Query.Parameter.List parameters)
void	Dispose ()
object	Scalar (string query)
T	Scalar< T > (string query)
Energy.Source.Connection	Copy ()
object	Clone ()
override string	ToString ()
Public Member Functions inherited from Energy.Interface.ICopy< Connection >
T	Copy ()
	Make copy of object More...

Static Public Member Functions
static	operator Energy.Source.Connection (DbConnection connection)
static bool	IsActive (IDbConnection connection)
	Check if database connection is active More...
static bool	IsRunning (IDbConnection connection)
	Check if database connection is actually working More...

Properties
static Connection	Empty [get]
	Represents empty object More...
string	ConnectionString [get, set]
	Connection string used for opening database connection More...
System.Type	Vendor [get, set]
	Connection vendor class for database connection More...
bool	Persistent [get, set]
	Persistent connection More...
int	Repeat [get, set]
	Repeat operation after recoverable error More...
int	Timeout [get, set]
	Time limit in seconds for SQL operations More...
Energy.Core.Log.Logger	Logger [get, set]
	Log More...
Energy.Interface.IDialect	Dialect [get, set]
	Dialects More...
bool	ThreadOpen [get, set]
	Persistent connection More...
bool	ThreadEvent [get, set]
	Persistent connection More...
int	ErrorNumber [get]
	Error error number More...
string	ErrorMessage [get]
	Last error status More...
Exception	ErrorException [get]
	Last error exception More...
bool	Active [get]
	True if connection is active More...

Events
EventHandler	OnCreate
	Event fired when vendor connection object is created by Activator. More...
EventHandler	OnOpen
EventHandler	OnClose

Detailed Description

Generic method with type of SQL connection driver class

Database connection interface for application. To create new connection you have to specify vendor class which implements IDbConnection compatible with ADO.NET.

Template Parameters

T

Constructor & Destructor Documentation

Connection() [1/7]

Energy.Source.Connection< T >.Connection

(

)

Connection() [2/7]

Energy.Source.Connection< T >.Connection

(

string

connectionString

)

Connection() [3/7]

Energy.Source.Connection< T >.Connection

(

)

Connection() [4/7]

Energy.Source.Connection< T >.Connection

(

Type

vendor

)

Connection() [5/7]

Energy.Source.Connection< T >.Connection	(	Type	vendor,
		string	connectionString
	)

Connection() [6/7]

Energy.Source.Connection< T >.Connection	(	Type	vendor,
		Configuration	configuration
	)

Connection() [7/7]

Energy.Source.Connection< T >.Connection

(

IDbConnection< T >

connection

)

Member Function Documentation

Clone()

object Energy.Source.Connection< T >.Clone

(

)

Close()

void Energy.Source.Connection< T >.Close

(

)

Close existing connection

Copy()

Energy.Source.Connection Energy.Source.Connection< T >.Copy

(

)

Create()

IDbConnection Energy.Source.Connection< T >.Create

(

)

Create connection object of vendor class

Used by Open() to create DbConnection object.

Returns

Dispose()

void Energy.Source.Connection< T >.Dispose

(

)

Execute()

int Energy.Source.Connection< T >.Execute

(

string

query

)

Fetch()

Energy.Base.Table Energy.Source.Connection< T >.Fetch

(

string

query

)

Fetch query results into Energy.Base.Table

Parameters

query

Returns

GetErrorText()

string Energy.Source.Connection< T >.GetErrorText

(

)

Get error text

Returns

IsActive()

static bool Energy.Source.Connection< T >.IsActive ( IDbConnection< T >  connection )

static

Check if database connection is active

Parameters

connection

Returns

IsRunning()

static bool Energy.Source.Connection< T >.IsRunning ( IDbConnection< T >  connection )

static

Check if database connection is actually working

Parameters

connection

Returns

Load()

DataTable Energy.Source.Connection< T >.Load

(

string

query

)

Load data from query into DataTable

Parameters

query

Returns

Open() [1/2]

IDbConnection Energy.Source.Connection< T >.Open

(

IDbConnection< T >

connection

)

Open() [2/2]

IDbConnection Energy.Source.Connection< T >.Open

(

)

operator Energy.Source.Connection()

static Energy.Source.Connection< T >.operator Energy.Source.Connection ( DbConnection< T >  connection )

explicitstatic

Parse() [1/2]

string Energy.Source.Connection< T >.Parse

(

string

query

)

Parse() [2/2]

string Energy.Source.Connection< T >.Parse	(	string	query,
		Energy.Query.Parameter.List	parameters
	)

Prepare()

IDbCommand Energy.Source.Connection< T >.Prepare	(	IDbConnection< T >	connection,
		string	query
	)

Read()

DataTable Energy.Source.Connection< T >.Read

(

string

query

)

Read query results into DataTable.

Parameters

query

Returns

Scalar()

object Energy.Source.Connection< T >.Scalar

(

string

query

)

Scalar< T >()

T Energy.Source.Connection< T >.Scalar< T >

(

string

query

)

Test()

bool Energy.Source.Connection< T >.Test

(

)

Test database connection

Returns

ToString()

override string Energy.Source.Connection< T >.ToString

(

)

Property Documentation

Active

bool Energy.Source.Connection< T >.Active

get

True if connection is active

ConnectionString

string Energy.Source.Connection< T >.ConnectionString

getset

Connection string used for opening database connection

Dialect

Energy.Interface.IDialect Energy.Source.Connection< T >.Dialect

getset

Dialects

Empty

Connection Energy.Source.Connection< T >.Empty

staticget

Represents empty object

ErrorException

Exception Energy.Source.Connection< T >.ErrorException

get

Last error exception

ErrorMessage

string Energy.Source.Connection< T >.ErrorMessage

get

Last error status

ErrorNumber

int Energy.Source.Connection< T >.ErrorNumber

get

Error error number

Logger

Energy.Core.Log.Logger Energy.Source.Connection< T >.Logger

getset

Log

Persistent

bool Energy.Source.Connection< T >.Persistent

getset

Persistent connection

Repeat

int Energy.Source.Connection< T >.Repeat

getset

Repeat operation after recoverable error

ThreadEvent

bool Energy.Source.Connection< T >.ThreadEvent

getset

Persistent connection

ThreadOpen

bool Energy.Source.Connection< T >.ThreadOpen

getset

Persistent connection

Timeout

int Energy.Source.Connection< T >.Timeout

getset

Time limit in seconds for SQL operations

Vendor

System.Type Energy.Source.Connection< T >.Vendor

getset

Connection vendor class for database connection

Event Documentation

OnClose

EventHandler Energy.Source.Connection< T >.OnClose

OnCreate

EventHandler Energy.Source.Connection< T >.OnCreate

Event fired when vendor connection object is created by Activator.

OnOpen

EventHandler Energy.Source.Connection< T >.OnOpen

---

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

• Connection.cs