ADO.NET 幻影读取数据库示例与事务处理

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=GDMU;Integrated Security=True;Pooling=False");
            con.Open();
            SqlConnection con1 = new SqlConnection("Data Source=.;Initial Catalog=GDMU;Integrated Security=True;Pooling=False");
            con1.Open();
            SqlCommand cmd=new SqlCommand();
            cmd.Connection=con;
            SqlCommand cmd1 = new SqlCommand();
            cmd1.Connection = con1;
            SqlTransaction Trans = null;
            SqlTransaction Trans1 = null; ;
            try 
            {
                Trans = con.BeginTransaction();
                Trans1 = con1.BeginTransaction(IsolationLevel.RepeatableRead);
                cmd.Transaction = Trans;
                cmd1.Transaction = Trans1;
                cmd1.CommandText = "Select Count(*) from bank";
                int count =Convert.ToInt32(cmd1.ExecuteScalar());