.NET1.0/1.1的创建方式
1
enum provider {sqlserver, oracle, oledb, odbc};
2
provider prov = GetProviderFromConfigFile();
3IDbConnection conn = null;
4switch (prov)
5{
6
case provider.sqlserver:
7 conn = new SqlConnection();break;
8 case provider.oracle:
9 conn = new OracleConnection();break;
10 //
..
11
}
enum provider {sqlserver, oracle, oledb, odbc};
2
provider prov = GetProviderFromConfigFile();3
IDbConnection conn = null;4
switch (prov)5
{6
case provider.sqlserver:7
conn = new SqlConnection();break;8
case provider.oracle:9
conn = new OracleConnection();break;10
//..11
}.NET2.0的创建方式
1enum provider {sqlserver, oracle, oledb, odbc};
2public DbConnection GetConnectionBaseClass()
3{
4 provider prov = GetProviderFromConfigFile();
5 DbConnection conn = null;
6 switch (prov)
7
{
8 case provider.sqlserver:
9 conn = new SqlConnection();break;
10 case provider.oracle:
11 conn = new OracleConnection();break;
12 //.
13
}
14 return conn;
15}
16
enum provider {sqlserver, oracle, oledb, odbc};2
public DbConnection GetConnectionBaseClass()3
{4
provider prov = GetProviderFromConfigFile();5
DbConnection conn = null;6
switch (prov)7
{
8
case provider.sqlserver:9
conn = new SqlConnection();break;10
case provider.oracle:11
conn = new OracleConnection();break;12
//.13
}14
return conn;15
}16
两者的差别在于,2.0新提供了一个"中间层",就是在数据接口中增加了一个基类,所有的数据连接都要经过这个基类.也就是说1.0/1.1是以接口形方式产生的,而到了2.0里是以一个类的对象的形式产生的连接.这样,也就更加"直观"一些了.
