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); }