public async Task <List <TEntity> > ListGoAsync()
{
List <TEntity> entityList;
using (var reader = await StatementExecutor.ExecuteReaderAsync(Sql()))
{
entityList = EntityMapper.MapList <TEntity>(reader);
}
return(entityList);
}
public override async Task <IEnumerable <TEntity> > GoAsync()
{
IEnumerable <TEntity> entities;
using (var reader = await StatementExecutor.ExecuteReaderAsync(Sql()))
{
entities = EntityMapper.Map <TEntity>(reader);
}
return(entities);
}
public async Task <IEnumerable <TEntity> > UnionAsync(List <UnionSql> Sqls)
{
if (Sqls.Count() == 0)
{
return(Go());
}
using (var reader = await StatementExecutor.ExecuteReaderAsync(UnionSql(Sqls)))
{
return(EntityMapper.Map <TEntity>(reader));
}
}
public async Task <TLEntity> ListEntityGoAsync <TLEntity>() where TLEntity : List <TEntity>, new()
{
TLEntity lentity;
using (var reader = await StatementExecutor.ExecuteReaderAsync(Sql()))
{
lentity = EntityMapper.MapEntityList <TLEntity, TEntity>(reader);
}
return(lentity);
}
public override async Task <TEntity> GoAsync()
{
if (IsAutoIncrement)
{
using (var reader = await StatementExecutor.ExecuteReaderAsync(Sql()))
{
return(EntityMapper.Map <TEntity>(reader).FirstOrDefault());
}
}
var num = await StatementExecutor.ExecuteNonQueryAsync(Sql());
return(entity);
}
public override async Task <IEnumerable <TEntity> > GoAsync()
{
if (string.IsNullOrWhiteSpace(Sql))
{
throw new MissingSqlException();
}
IEnumerable <TEntity> entities;
using (var reader = await StatementExecutor.ExecuteReaderAsync(Sql))
{
entities = entityMapper.Map <TEntity>(reader);
}
return(entities);
}
public async Task ExecuteAsyncQueryUsingProvidedConnectionAsync()
{
var statementExecutor = new StatementExecutor(this.logger, this.target);
const string Sql = "SELECT * FROM Test";
var rowsCount = 0;
using (var reader = await statementExecutor.ExecuteReaderAsync(Sql))
{
while (reader.Read())
{
rowsCount++;
}
}
rowsCount.Should()
.Be(4);
}
public async Task <List <TEntity> > ListEntityGoAsync()
{
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(Sql());
IDataReader reader = dataReader;
dataReader = null;
List <TEntity> entityList;
try
{
entityList = EntityMapper.MapList <TEntity>(reader);
}
finally
{
reader?.Dispose();
}
return(entityList);
}
public async Task <TLEntity> ListEntityGoAsync <TLEntity>() where TLEntity : List <TEntity>, new()
{
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(Sql());
IDataReader reader = dataReader;
dataReader = null;
TLEntity lentity;
try
{
lentity = EntityMapper.MapEntityList <TLEntity, TEntity>(reader);
}
finally
{
reader?.Dispose();
}
return(lentity);
}
public override async Task <IEnumerable <TEntity> > GoAsync()
{
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(Sql());
IDataReader reader = dataReader;
dataReader = null;
IEnumerable <TEntity> entities;
try
{
entities = EntityMapper.Map <TEntity>(reader);
}
finally
{
reader?.Dispose();
}
return(entities);
}
public async Task <IEnumerable <TEntity> > UnionAsync(List <UnionSql> Sqls)
{
if (Sqls.Count() == 0)
{
return(Go());
}
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(UnionSql(Sqls));
IDataReader reader = dataReader;
dataReader = null;
try
{
return(EntityMapper.Map <TEntity>(reader));
}
finally
{
reader?.Dispose();
}
}
public override async Task <TEntity> GoAsync()
{
if (IsAutoIncrement)
{
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(Sql());
IDataReader reader = dataReader;
dataReader = null;
try
{
return(EntityMapper.Map <TEntity>(reader).FirstOrDefault());
}
finally
{
reader?.Dispose();
}
}
int num = await StatementExecutor.ExecuteNonQueryAsync(Sql());
return(entity);
}
public override async Task <IEnumerable <TEntity> > GoAsync()
{
if (string.IsNullOrWhiteSpace(Sql))
{
throw new MissingSqlException();
}
IDataReader dataReader = await StatementExecutor.ExecuteReaderAsync(Sql);
IDataReader reader = dataReader;
dataReader = null;
IEnumerable <TEntity> entities;
try
{
entities = entityMapper.Map <TEntity>(reader);
}
finally
{
reader?.Dispose();
}
return(entities);
}
