public async Task <IEnumerable <FullTextIndex> > SelectIndexesAsync()
{
IList <FullTextIndex> output = null;
using (var context = _dbContext)
{
output = await context.ExecuteReaderAsync(
CommandType.Text,
BySql,
async reader =>
{
if ((reader != null) && (reader.HasRows))
{
output = new List <FullTextIndex>();
while (await reader.ReadAsync())
{
var index = new FullTextIndex();
index.PopulateModel(reader);
output.Add(index);
}
}
return(output);
});
// Remove table prefix from table names
if (output != null)
{
foreach (var index in output)
{
index.TableName = index.TableName.Replace(context.Configuration.TablePrefix, "");
}
}
}
return(output);
}
