示例#1
0
        public async static Task <GridReader> TestMultipleResultSet(int pageIndex, int pageSize)
        {
            var query = "usp_GetAllBlogPostByPageIndex";
            var param = new DynamicParameters();

            param.Add("@PageIndex", pageIndex);
            param.Add("@PageSize", pageSize);
            var reader = dao.ReceiveBulkData(query, param);

            //var list = await SqlMapper.QueryAsync<Blog>(_connectionFactory.GetConnection, query, param, commandType: CommandType.StoredProcedure);

            //var reader = _connectionFactory.GetConnection.QueryMultiple(query, param: param, commandType: CommandType.StoredProcedure);
            //var CategoryOneList = reader.Read<Blog>().ToList();
            //var CategoryTwoList = reader.Read<ResultDrive>().ToList();
            //return reader;

            return(await reader);
        }