//Delete a user
            MyUser u = new MyUser() { Id = "testId" };
            dao.Execute(QueryInfo.GetSQLUpdate(typeof(MyUser)),u);

 1 // SP返回2个结果集10行 Users,Offices,同时返回两表总函数
 2             QueryInfo info = new QueryInfo();
 3             info.NamedQuery = "TEST_DAPPER_USERS";
 4             info.AddParam("UserCode", "y%");
 5             info.AddParam("out_TotalCount", 1);
 6             info.AddParam("out_TotalCount2", 1);
 7             info.AddParam("out_cursor1", "CURSOR");
 8             info.AddParam("out_cursor2", "CURSOR");
 9 
10             var reader = dao.QueryMultiple(info);
11             
12             var user = reader.Read<MyUser>();
13             var office = reader.Read<MyOffice>();
14 
15             object i = reader.OutputParams["out_TotalCount"];
16             object j = reader.OutputParams["out_TotalCount2"];

IDictionary<string, object> param = new Dictionary<string, object>();
            param.Add("UserCode_RLK", "chen");//==> and UserCode like :UserCode  /'chen%'
            param.Add("CreatedOn_GEQ", "2011-09-01");//==> and CreatedOn >=:CreatedOn
            param.Add("IsActive", 1);//==> and IsActive=:IsActive

            QueryInfo info = new QueryInfo("SYS_USER u");
            info.OrderBy.Add("Name");

            info.AddParam(param);
            info.TotalCount = 1;//分页请求
            info.PageSize = 15;
            info.StartRecord = 10;
           
            info.MappingType=typeof(MyUser);
            info = dao.Query(info);

            //info.List=IList[10] Results of(MyUser)
            //info.TotalCount= counts of the table