C# Class LitDev.DataBase

Inheritance: IDisposable
ファイルを表示 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_oe property

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

adapterOdbc public_oe property

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

adapterOleDb public_oe property

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

adapterSQLite public_oe property

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

adapterSqlServer public_oe property

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

cnnMySql public_oe property

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

cnnOdbc public_oe property

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

cnnOleDb public_oe property

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

cnnSQLite public_oe property

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

cnnSqlServer public_oe property

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

commandMySql public_oe property

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

commandOdbc public_oe property

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

commandOleDb public_oe property

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

commandSQLite public_oe property

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

commandSqlServer public_oe property

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

database public_oe property

public string database
return string

dbConnection public_oe property

public string dbConnection
return string

dbType public_oe property

public DBType dbType
return DBType

id public_oe property

public int id
return int

name public_oe property

public string name
return string