using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Threading;
using System.Data.Sql;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {


            //以每10000条为一个分隔点
            //增加一列ID，最好是自动增长，然后设置为聚集索引
            string cmdstr1 = @"select * from D where ID>0 and ID<5";
            string cmdstr2 = @"select * from D where ID>5 and ID<10";

            //第一个线程
            Task.Factory.StartNew(new Action(() =>
                {
                    NewMethod(cmdstr1);
                }));


            //第二个线程
            Task.Factory.StartNew(new Action(() =>
            {
                NewMethod(cmdstr2);
            }));
            Console.ReadKey();

        }

        private static void NewMethod(string cmdstr1)
        {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=mydb;Persist Security Info=True;User ID=sa;Password=12314;MultipleActiveResultSets=True");
            con.Open();
            SqlCommand cmd = new SqlCommand(cmdstr1, con);
            IAsyncResult result = cmd.BeginExecuteReader(new AsyncCallback((ar) =>
            {
            }), cmd);

            SqlDataReader dataReader = cmd.EndExecuteReader(result);
            if (dataReader.HasRows)
            {
                if (dataReader.Read())
                {
                    Console.WriteLine(dataReader["LastTime"]);
                }
            }
            con.Close();
        }
    }
}