using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; namespace ConsoleApplication2 {     class Program     {         static void Main(string[] args)         {             SqlConnection conn = new SqlConnection();             SqlCommand comm = new SqlCommand();             DateTime t1, t2;             int count = 10000;  //循环次数             string times;             conn.ConnectionString = "Data Source=.;Initial Catalog=Server;Integrated Security=True";             comm.CommandText = "insert into test (Cid,Cvalue) values('1','1')"; //数据插入             comm.Connection = conn;             Console.WriteLine("开始插入数据\r\n开始时间:" +(t1=DateTime.Now).ToLongTimeString());             try             {                 conn.Open();                 for (int i = 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 = "delete from test";                 //comm.ExecuteNonQuery();                 //Console.WriteLine("测试数据已删除");             }             catch (Exception err)             {                 Console.WriteLine(err.Message);             }             finally             {                 comm = null;                 conn.Close();                 conn.Close();             }             Console.ReadKey();         }         /// <summary>         /// 返回两个时间对象的时间间隔         /// </summary>         private static TimeSpan GetTimeSpan(DateTime t1, DateTime t2)         {             DateTime t3;             if (DateTime.Compare(t1, t2) == 1)             {                 t3 = t1;                 t1 = t2;                 t2 = t3;             }             return t2.Subtract(t1);         }     } }