1    [Test]
 2        public void TestSelectSql()
 3        {
 4            try
 5            {
 6                //创建临时表
 7                DBFactorySingleton.GetInstance().ExecuteSql("create table testSql (id int,name varchar(20)) ");
 8            }
 9            catch(Exception)
10            {
11                //删除临时数据
12                DBFactorySingleton.GetInstance().ExecuteSql("drop table testSql ");
13                //创建临时表
14                DBFactorySingleton.GetInstance().ExecuteSql("create table testSql (id int,name varchar(20)) ");
15
16            }
17            
18            //插入数据
19            DBFactorySingleton.GetInstance().ExecuteSql("insert into testSql values(1,'10')");
20            DBFactorySingleton.GetInstance().ExecuteSql("insert into testSql values(2,'20')");
21
22            string selectSql="select * from testSql";
23            //查询数据
24            IDataReader read= DBFactorySingleton.GetInstance().SelectSql(selectSql);
25            Assert.IsNotNull(read);
26
27            read.Read();
28            Assert.AreEqual( read[0].ToString(),"1");
29            Assert.AreEqual( read[1].ToString(),"10");
30
31            read.Read();
32            Assert.AreEqual( read[0].ToString(),"2");
33            Assert.AreEqual( read[1].ToString(),"20");
34
35            Assert.IsFalse( read.Read());   //只有两条记录
36            read.Close();
37    //添加一列 
38            DBFactorySingleton.GetInstance().ExecuteSql("alter table testSql add testcolumn int");
39
40            
41            //查询数据
42            read= DBFactorySingleton.GetInstance().SelectSql(selectSql);
43            Assert.IsNotNull(read);
44
45            
46            read.Read();
47            Assert.AreEqual(3,read.FieldCount) ;
48            
49            read.Close();
50//删除临时数据
51            DBFactorySingleton.GetInstance().ExecuteSql("drop table testSql ");
52        }