/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <param name="args"></param>
/// <returns></returns>
public virtual Task <IDataSetResult> ExecuteDataSetAsync(string sql, params object[] args)
{
IDataSetResult returnValue = new DataSetResult();
using (OleDbCommand cmd = new OleDbCommand(String.Format(sql, args), this.BatchToken.Connection, this.InternalTransaction))
{
using (OleDbDataAdapter adp = new OleDbDataAdapter(cmd))
{
returnValue.Affected = adp.Fill(returnValue.Data);
}
}
return(Task.FromResult(returnValue));
}
/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <param name="args"></param>
/// <returns></returns>
public virtual Task <IDataSetResult> ExecuteDataSetAsync(string sql, params object[] args)
{
IDataSetResult returnValue = new DataSetResult();
lock (_lockObject)
{
OleDbConnection connection = this.Connection;
try
{
using (OleDbDataAdapter adp = new OleDbDataAdapter(String.Format(sql, args), connection))
{
returnValue.Affected = adp.Fill(returnValue.Data);
}
}
finally
{
this.ConnectionShutdownAsync(connection);
connection = null;
}
}
return(Task.FromResult(returnValue));
}
