Csharp/C#教程：c#测试本机sql运算速度的代码示例分享分享

代码如下:
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data.SqlClient;

namespaceConsoleApplication2
{
   classProgram
   {
       staticvoidMain(string[]args)
       {
           SqlConnectionconn=newSqlConnection();
           SqlCommandcomm=newSqlCommand();
           DateTimet1,t2;
           intcount=10000; //循环次数
           stringtimes;
           conn.ConnectionString=”DataSource=.;InitialCatalog=Server;IntegratedSecurity=True”;
           comm.CommandText=”insertintotest(Cid,Cvalue)values(‘1′,’1’)”;//数据插入
           comm.Connection=conn;
           Console.WriteLine(“开始插入数据rn开始时间:”+(t1=DateTime.Now).ToLongTimeString());
           try
           {
               conn.Open();
               for(inti=1;i<=count;i++)
               {
                   comm.ExecuteNonQuery();//执行查询
               }
               Console.WriteLine(“结束时间:”+(t2=DateTime.Now).ToLongTimeString());
               times=GetTimeSpan(t1,t2).ToString();
               Console.WriteLine(“持续时间:”+times.Substring(0,times.LastIndexOf(“.”)+4));
               Console.WriteLine(“本次测试总共对数据库进行了”+count+”次数据插入操作！”);
               //comm.CommandText=”deletefromtest”;
               //comm.ExecuteNonQuery();
               //Console.WriteLine(“测试数据已删除”);
           }
           catch(Exceptionerr)
           {
               Console.WriteLine(err.Message);
           }
           finally
           {
               comm=null;
               conn.Close();
               conn.Close();
           }
           Console.ReadKey();       }

C++常用字符串分割方法实例汇总