第C#OleDbDataReader快速數(shù)據(jù)讀取方式(3種)關(guān)于速度的描述，下面我們來簡單驗證一下。

有一個數(shù)據(jù)庫，數(shù)據(jù)庫中的表TEST有105945行數(shù)據(jù)，設(shè)計一個循環(huán)讀取來測試他們的讀取速度。

測試源碼如下：

staticvoidMain(string[]args)

stringconnstr=string.Format("Provider=Microsoft.Jet.OLEDB.4.0;DataSource={0};","F:\\2.mdb");

strings1="ID";

strings2="探測號";

strings3="X";

strings4="Y";

strings5="H";

stringsql=string.Format("SELECT{0},{1},{2},{3},{4}FROM管點表",s1,s2,s3,s4,s5);

TimeSpantime1=newTimeSpan();

TimeSpantime2=newTimeSpan();

TimeSpantime3=newTimeSpan();

intcount=50;

//數(shù)據(jù)庫中查詢的表有105945行

for(inti=0;icount;i++)

using(OleDbConnectionconn=newOleDbConnection(connstr))

#region

conn.Open();

OleDbCommandcommand=conn.CreateCommand();

command.CommandText=sql;

OleDbDataReaderreader=command.ExecuteReader();

DateTimenow=DateTime.Now;

while(reader.Read())

vart1=reader[0];vart2=reader[1];vart3=reader[2];vart4=reader[3];vart5=reader[4];

time1=time1+(DateTime.Now-now);

#endregion

for(inti=0;icount;i++)

using(OleDbConnectionconn=newOleDbConnection(connstr))

#region

conn.Open();

OleDbCommandcommand2=conn.CreateCommand();

command2.CommandText=sql;

OleDbDataReaderreader=command2.ExecuteReader();

DateTimenow=DateTime.Now;

while(reader.Read())

vart1=reader[s1];vart2=reader[s2];vart3=reader[s3];vart4=reader[s4];vart5=reader[s5];

time2=time2+(DateTime.Now-now);

#endregion

for(inti=0;icount;i++)

using(OleDbConnectionconn=newOleDbConnection(connstr))

#region

conn.Open();

OleDbCommandcommand3=conn.CreateCommand();

command3.CommandText=sql;

OleDbDataReaderreader=command3.ExecuteReader();

DateTimenow=DateTime.Now;

while(reader.Read())

vart1=reader.GetValue(0);vart2=reader.GetValue(1);vart3=reader.GetValue(2);vart4=reader.GetValue(3);vart5=reader.GetValue(4);

time3=time3+(DateTime.Now-now);

#endregion

Console.WriteLine(string.Format("方法一：\r\n耗時：{0}s",time1.TotalSeconds));

Console.WriteLine(string.Format("方法二：\r\n耗時：{0}s",time2.TotalSeconds));

Console.WriteLine(string.Format("方法三：\r\n耗時：{0}s",time3.TotalSeconds));

Console.ReadK