private IDbConnection InitializeConnection(EvanDataProvider dp)
{
switch (dp)
{
case EvanDataProvider.SqlClient:
case EvanDataProvider.SqlServer:
case EvanDataProvider.SqlExpress:
con = new SqlConnection();
break;
case EvanDataProvider.OleDb:
con = new OleDbConnection();
break;
case EvanDataProvider.Odbc:
con = new OdbcConnection();
break;
//case EvanDataProvider.SqlServerCe:
// con = new SqlCeConnection();
// break;
case EvanDataProvider.MySql:
//con = new MySqlConnection();
break;
case EvanDataProvider.Access12:
con = new OleDbConnection();
break;
}
this.con.ConnectionString = this.cnStr;
return(this.con);
}
public void Entry()
{
EvanDataProvider provider = EvanDataProvider.None;
this.GetProvider();
provider = (EvanDataProvider)Enum.Parse(typeof(EvanDataProvider), dataProvString);
IDbConnection con = InitializeConnection(provider);
con.ConnectionString = cnStr;
con.Open();
IDbCommand cmd = con.CreateCommand();
string sql = "select * from Student";
cmd.CommandText = sql;
IDataReader id = cmd.ExecuteReader();
while (id.Read())
{
Console.WriteLine(id.GetString(2));
}
con.Close();
}
