c# mysql封装类_C#数据库封装类转载)

usingSystem;

usingSystem.Collections.Generic;

usingSystem.Text;

usingSystem.Data;

usingSystem.Configuration;

usingSystem.Data.Common;

usingSystem.Data.SqlClient;

usingSystem.Data.OleDb;

usingSystem.Data.Odbc;

usingSystem.Data.OracleClient;

usingSystem.IO;

namespaceBinaryIntellect.DataAccess

{

public classDatabaseHelper: IDisposable{

private stringstrConnectionString;

privateDbConnection objConnection;

privateDbCommand objCommand;

privateDbProviderFactory objFactory = null;

private boolboolHandleErrors;

private stringstrLastError;

private boolboolLogError;

private stringstrLogFile;

publicDatabaseHelper(stringconnectionstring, Providers provider)

{

strConnectionString = connectionstring;

switch(provider)

{

caseProviders.SqlServer:

objFactory = SqlClientFactory.Instance;

break;

caseProviders.OleDb:

objFactory = OleDbFactory.Instance;

break;

caseProviders.Oracle:

objFactory = OracleClientFactory.Instance;

break;

caseProviders.ODBC:

objFactory = OdbcFactory.Instance;

break;

caseProviders.ConfigDefined:

stringprovidername = ConfigurationManager.ConnectionStrings["connectionstring"].ProviderName;

switch(providername)

{

case"System.Data.SqlClient":

objFactory = SqlClientFactory.Instance;

break;

case"System.Data.OleDb":

objFactory = OleDbFactory.Instance;

break;

case"System.Data.OracleClient":

objFactory = OracleClientFactory.Instance;

break;

case"System.Data.Odbc":

objFactory = OdbcFactory.Instance;

break;

}

break;

}

objConnection = objFactory.CreateConnection();

objCommand = objFactory.CreateCommand();