public async Task <IActionResult> Get()
{
//Repo.BeginTransaction();
//var result = await Repo.QueryFirstOrDefaultAsync("select * from goods ;");
//Repo.CommitTransaction();
//return Ok(result);
var r1 = await Repo1.QueryAsync <object>("select * from COMPANY where id=1 LIMIT 1 OFFSET 0", enableCache : true, cacheExpire : TimeSpan.FromSeconds(100));
int pageindex = 1;
var page = await Repo2.QueryPageAsync <object>("select count(*) from COMPANY;", "select * from COMPANY limit @Take OFFSET @Skip;", pageindex, 20, enableCache : true, cacheKey : $"page:{pageindex}");
////var r2 = await Repo2.QueryAsync("select * from COMPANY where id=2 LIMIT 1 OFFSET 0");
//return Ok(new
//{
// SQLite = new { r1, page },
// //SQL = new
// //{
// // page = await SQLRepo.QueryPageAsync("select count(*) from Company;", "select * from Company;", 1, 20)
// //}
//});
var con = Repo2.Query("select * from company;");
var list = await Repo1.QueryAsync <object>(name : "COMPANY.list.query", new { id = 1 });
var sql = Repo1.GetSQL("contact.query");
var r = await Repo1.QueryAsync <Contact, Passport, Contact>(sql, (contact, passport) =>
{
contact.Passport = passport;
return(contact);
}, null, "PassportNumber");
return(Ok(new { r1, page }));
}
