I have a web application that uses old school SqlHelper class.
I want to create my custom SqlHelper which uses Dapper underneath. So, how can I get SqlDataReader from Dapper?
asked Sep 21, 2014 at 7:52
Imran Qadir Baksh - Baloch
34.3k69 gold badges198 silver badges351 bronze badges
-
I'm not dapper expert, but dapper is created to work on object layer(it's Micro ORM) and not worried about usual ado.net stuff including SqlDataReader.reptildarat– reptildarat2014-09-21 07:59:46 +00:00Commented Sep 21, 2014 at 7:59
-
1@reptildarat, I know. But I need this for a reason.Imran Qadir Baksh - Baloch– Imran Qadir Baksh - Baloch2014-09-21 08:04:14 +00:00Commented Sep 21, 2014 at 8:04
Add a comment
|
1 Answer
There is an ExecuteReader method that hands you back the data-reader that the connection generated: you can cast this if you know it is actually a SqlDataReader. In this scenario, dapper only processes parameters and literal injection.
using(var reader = (DbDataReader)
conn.ExecuteReader(sql, args))
{
// use reader here
}
I am, however, more than a little intrigued as to what you want SqlHelper to do that dapper doesn't already do (but better). Genuine question: I like improving the library. If there is a gap, let me know.
14 Comments
Imran Qadir Baksh - Baloch
Thanks. Is there is ExecuteReaderAsync as well?
Marc Gravell
@user yes - in the .NET 4.5 build
Marc Gravell
@user I am familiar with it; I was curious if I'd simply omitted some huge feature set. It doesn't sound like it...
Marc Gravell
@user960567 the way to do that would be to write a class that implements ICustomParameters or ICustomParameter - and wrap that. It should work fine. I'm not at a PC, but let me know if you need an example adding later. Dapper works fine with TVPs.
Phill
@MarcGravell this broke in Dapper 2.0.4, in 1.60.6 you could cast it to a
SqlDataReader, now it fails. :( Need to use DbDataReader |
