Sylloge.Data.Database Class Reference

Provides base functionality to connect to and manipulate OLEDB or ODBC databases. More...

Inherited by Sylloge.Data.Odbc, and Sylloge.Data.OleDb.

List of all members.

Public Member Functions
	Database (Sylloge.Data.DatabaseType type)
	The default constructor.
void	Dispose ()
	Closes this instance and cleans up any resources.
void	Close ()
	Close the database.
bool	ColumnExists (string columnName)
	Checks if a column exist in the DataTable.
System.Data.DataTable	GetTables ()
	Gets the tables in the database as a System.Data.DataTable
bool	Open ()
	Opens the database using the previous database name and connection string.
System.Data.DataTable	Query (string table, string query)
	Query the database getting a System.Data.DataTable as a result.
Properties
System.Data.Common.DbDataAdapter	m_Adapter [get, set]
System.Data.Common.DbConnection	m_Conn [get, set]
string	m_ConnStr [get, set]
bool	m_IsOpen [get, set]
string	m_Name [get, set]
System.Data.DataTable	m_Table [get, set]
Sylloge.Data.DatabaseType	m_Type [get, set]
System.Data.DataSet	Dataset [get, set]
	Gets the underlying System.Data.DataSet of this instance.
Sylloge.Data.DatabaseType	Type [get]
	Gets the Sylloge.Data.DatabaseType of this instance.
bool	IsConnected [get]
	Gets if the database is connected.

---

Detailed Description

Provides base functionality to connect to and manipulate OLEDB or ODBC databases.

Definition at line 38 of file Database.cs.

---

Constructor & Destructor Documentation

Sylloge.Data.Database.Database

(

Sylloge.Data.DatabaseType

type

)

The default constructor.

Definition at line 81 of file Database.cs.

---

Member Function Documentation

void Sylloge.Data.Database.Close

(

)

Close the database.

Definition at line 106 of file Database.cs.

bool Sylloge.Data.Database.ColumnExists

(

string

columnName

)

Checks if a column exist in the DataTable.

Parameters:

columnName

The column name to look for

Returns:

True if the column exists in the table

Definition at line 127 of file Database.cs.

void Sylloge.Data.Database.Dispose

(

)

Closes this instance and cleans up any resources.

Definition at line 97 of file Database.cs.

System.Data.DataTable Sylloge.Data.Database.GetTables

(

)

Gets the tables in the database as a System.Data.DataTable

Returns:

A System.Data.DataTable with the databases tables

Definition at line 136 of file Database.cs.

bool Sylloge.Data.Database.Open

(

)

Opens the database using the previous database name and connection string.

Returns:

True on successful connection

Definition at line 189 of file Database.cs.

System.Data.DataTable Sylloge.Data.Database.Query	(	string	table,
		string	query
	)

Query the database getting a System.Data.DataTable as a result.

Parameters:

table	The table name in the database to query against
query	The query to submit

Returns:

The System.Data.DataTable retreived from the query

Exceptions:

System.Exception

System.Exception

Definition at line 234 of file Database.cs.

---

Property Documentation

System.Data.DataSet Sylloge.Data.Database.Dataset [get, set]

Gets the underlying System.Data.DataSet of this instance.

Definition at line 59 of file Database.cs.

bool Sylloge.Data.Database.IsConnected [get]

Gets if the database is connected.

Definition at line 178 of file Database.cs.

System.Data.Common.DbDataAdapter Sylloge.Data.Database.m_Adapter [get, set, protected]

Definition at line 44 of file Database.cs.

System.Data.Common.DbConnection Sylloge.Data.Database.m_Conn [get, set, protected]

Definition at line 45 of file Database.cs.

string Sylloge.Data.Database.m_ConnStr [get, set, protected]

Definition at line 46 of file Database.cs.

bool Sylloge.Data.Database.m_IsOpen [get, set, protected]

Definition at line 47 of file Database.cs.

string Sylloge.Data.Database.m_Name [get, set, protected]

Definition at line 48 of file Database.cs.

System.Data.DataTable Sylloge.Data.Database.m_Table [get, set, protected]

Definition at line 49 of file Database.cs.

Sylloge.Data.DatabaseType Sylloge.Data.Database.m_Type [get, set, protected]

Definition at line 50 of file Database.cs.

Sylloge.Data.DatabaseType Sylloge.Data.Database.Type [get]

Gets the Sylloge.Data.DatabaseType of this instance.

Definition at line 65 of file Database.cs.

---

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

• code/Data/Database.cs