dapper: Get result and count at same time using QueryMultiple

Question

dapper: Get result and count at same time using QueryMultiple

.net c# dapper sql sql-server

Question

I wrote two segments of SQL command and want to process in one query like this:

SELECT COUNT(*) FROM books

SELECT * FROM books ORDER BY bookID OFFSET 1000 ROWS FETCH NEXT 10 ROWS ONLY

How can I use conn.QueryMultiple method to get count AND list of books at same time ?

btw: I don't want to create any extra entity classes

ineztia

View more on Stack Overflow

Backs · Accepted Answer · 6/9/2016 3:07:40 AM

Accepted Answer

From github example:

var sql = @"SELECT COUNT(*) FROM books
            SELECT * FROM books ORDER BY bookID OFFSET 1000 ROWS FETCH NEXT 10 ROWS ONLY";

using(var multi = connection.QueryMultiple(sql))
{
    var count = multi.Read<int>().Single();
    var results = multi.Read<YourObject>().ToList();
}

Backs

dapper: Get result and count at same time using QueryMultiple

Question

Fastest Dapper Plus Extensions

Accepted Answer

Performance

Expression Evaluator