public async Task <IEnumerable <Table> > QueryTable()
{
_logger.LogInformation($"----Db:{DbName} Provider:{DbProviderName}, QueryTable Start! ----");
IEnumerable <Table> tables;
try
{
SqlMapper.BeginSession();
tables = await SqlMapper.QueryAsync <Table>(new RequestContext
{
Scope = Scope,
SqlId = "QueryTable",
Request = new { DBName = DbName }
});
foreach (var table in tables)
{
table.Columns = await SqlMapper.QueryAsync <Column>(new RequestContext
{
Scope = Scope,
SqlId = "QueryColumn",
Request = new { DBName = DbName, TableId = table.Id, TableName = table.Name }
});
}
}
finally
{
SqlMapper.EndSession();
}
_logger.LogInformation($"----Db:{DbName} Provider:{DbProviderName},Tables:{tables.Count()} QueryTable End! ----");
return(tables);
}
public void Query_Scoped()
{
int i = 0;
SqlMapper.BeginSession();
for (i = 0; i < testTime; i++)
{
var list = SqlMapper.Query <T_Test>(new RequestContext
{
Scope = "T_Test",
SqlId = "GetList",
});
}
SqlMapper.EndSession();
Assert.Equal <int>(i, testTime);
}