vendredi 15 juillet 2016

Dapper - How to use QueryMultiple(two database)

public MySqlConnection _db0= new MySqlConnection(ConfigurationManager.ConnectionStrings["db0"].ConnectionString);
public MySqlConnection _db1= new MySqlConnection(ConfigurationManager.ConnectionStrings["db1"].ConnectionString);
Payment result = new Payment();
_carduid = "EF22A";
long _accesscardid = _db0.GetList<AccessCard>(new { cardUID = _carduid }).FirstOrDefault().accessCardID;
long _bkid = _db0.GetList<BookingMapping>(new { accessCardID = _accesscardid }).FirstOrDefault().BKID;
long _bkdetailid = _db1.GetList<BookingDetail>(new { BKID = _bkid }).FirstOrDefault().bkDetailID;
var _payid = _db1.GetList<BookingPayment>(new { bkDetailID = _bkdetailid }).FirstOrDefault().PayID;
result = _db1.GetList<Payment>(new { payID = _payid }).FirstOrDefault();

TWO DATABASE, Dapper, Dapper.simpleCURD , T4 Template

How to use QueryMultiple in this case?

Aucun commentaire:

Enregistrer un commentaire