public Task <T[]> ToArrayAsync <T>(CancellationToken CancellationToken)
{
using (SqlCommand command = connection.GetCommand(commandText))
{
DatabaseTrace.Append(command.CommandText, Constant.Query);
if (connection.HasTransaction)
{
command.Transaction = connection.Transaction;
}
return(command.ExecuteReaderAsync(CommandBehavior.Default, CancellationToken)
.ContinueWith(task =>
{
T[] callback;
using (SqlDataReader reader = task.Result)
{
callback = DatabaseReaderSelect <T> .ToArrayAsync(reader, CancellationToken);
reader.Close();
}
return callback;
}));
}
}
public T FirstOrDefault <T>()
{
T callback = default;
using (SqlCommand command = connection.GetCommand(commandText))
{
DatabaseTrace.Append(command.CommandText, Constant.Query);
if (connection.HasTransaction)
{
command.Transaction = connection.Transaction;
}
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow))
{
if (reader.HasRows)
{
callback = DatabaseReaderSelect <T> .First(reader);
}
reader.Close();
}
}
return(callback);
}
public Task <T> FirstAsync <T>(CancellationToken CancellationToken)
{
using (SqlCommand command = connection.GetCommand(commandText))
{
DatabaseTrace.Append(command.CommandText, Constant.Query);
if (connection.HasTransaction)
{
command.Transaction = connection.Transaction;
}
return(command.ExecuteReaderAsync(CommandBehavior.SingleRow, CancellationToken)
.ContinueWith(task =>
{
bool read = false;
T callback = default;
using (SqlDataReader reader = task.Result)
{
if (reader.HasRows)
{
read = true;
}
if (read)
{
callback = DatabaseReaderSelect <T> .FirstAsync(reader, CancellationToken);
}
reader.Close();
if (!read)
{
throw new EntityDatabaseException($"Database Select FirstAsync {typeof(T).Name} Failed, Nothing Returned With Query : \n\n {commandText}");
}
return callback;
}
}));
}
}
public T[] ToArray <T>()
{
T[] callback;
using (SqlCommand command = connection.GetCommand(commandText))
{
DatabaseTrace.Append(command.CommandText, Constant.Query);
if (connection.HasTransaction)
{
command.Transaction = connection.Transaction;
}
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.Default))
{
callback = DatabaseReaderSelect <T> .ToArray(reader);
reader.Close();
}
}
return(callback);
}
public T First <T>()
{
bool read = false;
T callback = default;
using (SqlCommand command = connection.GetCommand(commandText))
{
DatabaseTrace.Append(command.CommandText, Constant.Query);
if (connection.HasTransaction)
{
command.Transaction = connection.Transaction;
}
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow))
{
if (reader.HasRows)
{
read = true;
}
if (read)
{
callback = DatabaseReaderSelect <T> .First(reader);
}
reader.Close();
}
}
if (!read)
{
throw new EntityDatabaseException($"Database Select First {typeof(T).Name} Failed, Nothing Returned With Query : \n\n {commandText}");
}
return(callback);
}
