mercredi 25 février 2015

How to use Dapper.QueryMultiple with Sqlite

The Dapper documentation states you can send off multiple queries at once and iterate over the results using the QueryMultiple method like so:



var sql = @"
select * from foo where id = @paramname
select * from bar where id = @paramname";

conn.QueryMultiple(sql, new {paramname = paramval});


It would appear using sqlite this doesn't work throwing up invalid sql near "select". How do I use querymultiple with sqlite?


Aucun commentaire:

Enregistrer un commentaire