How to check if record exists before reading in Dapper ORM

Question

How to check if record exists before reading in Dapper ORM

dapper

Question

Can anyone please suggest how to check if there are any records in the resultset using Dapper ORM.

Customer objCustomer = null;
using (SqlMapper.GridReader multiResult = new DapperRepository().QueryMultiple(sql, new { id = id }))
{
    objCustomer = multiResult.Read<Customer>().Single(); //null exception
}

Sunny

View more on Stack Overflow

Accepted Answer

Yes, write this:

objCustomer = multiResult.Read<Customer>().SingleOrDefault(); //return null if not exists without error

then you can check:

objCustomer != null

Hope this helps.

How to check if record exists before reading in Dapper ORM

Question

Accepted Answer

Performance

Expression Evaluator