C# Class LitDev.DataBase

Inheritance: IDisposable

Show file Open project: litdev1/LitDev Class Usage Examples

Public Properties

Property	Type	Description
adapterMySql	MySql.Data.MySqlClient.MySqlDataAdapter
adapterOdbc	System.Data.Odbc.OdbcDataAdapter
adapterOleDb	System.Data.OleDb.OleDbDataAdapter
adapterSQLite	System.Data.SQLite.SQLiteDataAdapter
adapterSqlServer	System.Data.SqlClient.SqlDataAdapter
cnnMySql	MySql.Data.MySqlClient.MySqlConnection
cnnOdbc	System.Data.Odbc.OdbcConnection
cnnOleDb	System.Data.OleDb.OleDbConnection
cnnSQLite	System.Data.SQLite.SQLiteConnection
cnnSqlServer	System.Data.SqlClient.SqlConnection
commandMySql	MySql.Data.MySqlClient.MySqlCommand
commandOdbc	System.Data.Odbc.OdbcCommand
commandOleDb	System.Data.OleDb.OleDbCommand
commandSQLite	System.Data.SQLite.SQLiteCommand
commandSqlServer	System.Data.SqlClient.SqlCommand
database	string
dbConnection	string
dbType	DBType
id	int
name	string

Public Methods

Method	Description
ConnectMySql ( string server, string user, string password ) : void
ConnectOdbc ( string driver, string server, Primitive port, string user, string password, string option ) : void
ConnectOleDb ( string provider, string server ) : void
ConnectSQLite ( ) : void
ConnectSqlServer ( string server ) : void
DataBase ( string database, int id ) : System
Dispose ( ) : void

Protected Methods

Method	Description
Dispose ( bool disposing ) : void

Method Details

ConnectMySql() public method

public ConnectMySql ( string server, string user, string password ) : void
server	string
user	string
password	string
return	void

ConnectOdbc() public method

public ConnectOdbc ( string driver, string server, Primitive port, string user, string password, string option ) : void
driver	string
server	string
port	Primitive
user	string
password	string
option	string
return	void

ConnectOleDb() public method

public ConnectOleDb ( string provider, string server ) : void
provider	string
server	string
return	void

ConnectSQLite() public method

public ConnectSQLite ( ) : void
return	void

ConnectSqlServer() public method

public ConnectSqlServer ( string server ) : void
server	string
return	void

DataBase() public method

public DataBase ( string database, int id ) : System
database	string
id	int
return	System

Dispose() public method

public Dispose ( ) : void
return	void

Dispose() protected method

protected Dispose ( bool disposing ) : void
disposing	bool
return	void

Property Details

adapterMySql public property

public MySqlDataAdapter,MySql.Data.MySqlClient adapterMySql
return	MySql.Data.MySqlClient.MySqlDataAdapter

adapterOdbc public property

public OdbcDataAdapter,System.Data.Odbc adapterOdbc
return	System.Data.Odbc.OdbcDataAdapter

adapterOleDb public property

public OleDbDataAdapter,System.Data.OleDb adapterOleDb
return	System.Data.OleDb.OleDbDataAdapter

adapterSQLite public property

public SQLiteDataAdapter,System.Data.SQLite adapterSQLite
return	System.Data.SQLite.SQLiteDataAdapter

adapterSqlServer public property

public SqlDataAdapter,System.Data.SqlClient adapterSqlServer
return	System.Data.SqlClient.SqlDataAdapter

cnnMySql public property

public MySqlConnection,MySql.Data.MySqlClient cnnMySql
return	MySql.Data.MySqlClient.MySqlConnection

cnnOdbc public property

public OdbcConnection,System.Data.Odbc cnnOdbc
return	System.Data.Odbc.OdbcConnection

cnnOleDb public property

public OleDbConnection,System.Data.OleDb cnnOleDb
return	System.Data.OleDb.OleDbConnection

cnnSQLite public property

public SQLiteConnection,System.Data.SQLite cnnSQLite
return	System.Data.SQLite.SQLiteConnection

cnnSqlServer public property

public SqlConnection,System.Data.SqlClient cnnSqlServer
return	System.Data.SqlClient.SqlConnection

commandMySql public property

public MySqlCommand,MySql.Data.MySqlClient commandMySql
return	MySql.Data.MySqlClient.MySqlCommand

commandOdbc public property

public OdbcCommand,System.Data.Odbc commandOdbc
return	System.Data.Odbc.OdbcCommand

commandOleDb public property

public OleDbCommand,System.Data.OleDb commandOleDb
return	System.Data.OleDb.OleDbCommand

commandSQLite public property

public SQLiteCommand,System.Data.SQLite commandSQLite
return	System.Data.SQLite.SQLiteCommand

commandSqlServer public property

public SqlCommand,System.Data.SqlClient commandSqlServer
return	System.Data.SqlClient.SqlCommand

database public property

public string database
return	string

dbConnection public property

public string dbConnection
return	string

dbType public property

public DBType dbType
return	DBType

id public property

public int id
return	int

name public property

public string name
return	string