C#:System.Data.Common命名空间（数据库抽象工厂的使用）

代码

/// 在使用本例之前要先手动引用system.configration组件，然后建立config文件，config文件名为当前程序文件名的后面加.config比如：a.exe.config
using  System;
using  System.Collections.Generic;
using  System.Text;
using  System.Configuration;
using  System.Data;
using  System.Data.SqlClient;
using  System.Data.Common;

namespace  ConsoleApplication313
{
     class  Program
    {
         static   void  Main( string [] args)
        {
            ConnectionStringSettings cfg  =  ConfigurationManager.ConnectionStrings[ " My DB " ];
            DbProviderFactory factory  =  DbProviderFactories.GetFactory(cfg.ProviderName);
            DbConnection cnx  =  factory.CreateConnection();
            DbCommand cmd  =  factory.CreateCommand();
            cnx.ConnectionString  =  cfg.ConnectionString;
            cmd.Connection  =  cnx;
            cnx.Open();
            cmd.CommandText  =   string .Format( " select * from student " );
            DbDataReader dbdatareader =
            cmd.ExecuteReader();
             while  (dbdatareader.Read())
            {
                Console.Write( string .Format( " {0} {1} {2} {3} {4} {5} " ,dbdatareader[ 0 ],dbdatareader[ 1 ],
                    dbdatareader[ 2 ],dbdatareader[ 3 ],dbdatareader[ 4 ],dbdatareader[ 5 ]));
                Console.WriteLine();
            }
            System.Console.ReadLine();
        }
    }
}

 

下面是XML文件的内容：

代码

<? xml version="1.0" encoding="utf-8" ?>
< configuration >
< connectionStrings >
    < add  name ="My DB"  providerName ="System.Data.SqlClient"  connectionString ="server=.;uid=sa;pwd=sqlserver;database=master" />
</ connectionStrings >
</ configuration >