/// <summary>
/// Executes a stored procedure or SQL batch asynchronously.
/// </summary>
/// <typeparam name="T">The type of the result set that is returned by the execution.</typeparam>
/// <param name="procOrBatch">Is a stored procedure or SQL batch.</param>
/// <param name="onCompleted">A delegate method that is called when the asynchronous operation completes.</param>
/// <returns>The object of the asynchronous operation.</returns>
public static Async <Result <T> > ExecGoAsync <T>(ExecArgument procOrBatch, Action <Result <T> > onCompleted = null)
{
return(Call <Async <Result <T> > >(Assembly.GetCallingAssembly(), (ca) =>
{
if (procOrBatch == null)
{
_Throw(QueryTalkExceptionType.ArgumentNull, "procOrBatch", ".ExecGoAsync");
}
var root = new d();
var cpass = PassChainer.Create(root, procOrBatch);
var connectable = Reader.GetConnectable(ca, cpass);
connectable.OnAsyncCompleted = onCompleted;
if (typeof(T) == typeof(DataTable))
{
return Reader.LoadDataTableAsync <T>(connectable);
}
else
{
return Reader.LoadTableAsync <T>(connectable, null);
}
}));
}
/// <summary>
/// <para>Executes a stored procedure or SQL batch.</para>
/// </summary>
/// <param name="procOrBatch">Is a stored procedure or SQL batch code.</param>
public static Result <T> ExecGo <T>(ExecArgument procOrBatch)
{
return(Call <Result <T> >(Assembly.GetCallingAssembly(), (ca) =>
{
if (procOrBatch == null)
{
_Throw(QueryTalkExceptionType.ArgumentNull, "procOrBatch", Wall.Text.Method.ExecGo);
}
var root = new d();
var cpass = PassChainer.Create(root, procOrBatch);
var connectable = Reader.GetConnectable(ca, cpass);
Result <T> result;
if (typeof(T) == typeof(DataTable))
{
result = Reader.LoadDataTable <T>(connectable);
}
else
{
result = Reader.LoadTable <T>(connectable, null);
}
return result;
}));
}
/// <summary>
/// Executes the stored procedure or SQL batch.
/// </summary>
/// <param name="prev">A predecessor object.</param>
/// <param name="procOrBatch">Is a stored procedure identifier, SQL batch code, or inliner of a stored procedure.</param>
/// <param name="returnValueToVariable">Is a name of the variable where the RETURN VALUE returned by the stored procedure will be stored.</param>
public static ExecChainer Exec(this IAny prev, ExecArgument procOrBatch, string returnValueToVariable = null)
{
if (procOrBatch == null)
{
throw new QueryTalkException("Exec", QueryTalkExceptionType.ArgumentNull, "procOrBatch = null", Text.Method.Exec);
}
return(ExecChainer.Create((Chainer)prev, procOrBatch, returnValueToVariable, procOrBatch.Arguments));
}
/// <summary>
/// Executes a stored procedure or SQL batch.
/// </summary>
/// <param name="procOrBatch">Is a stored procedure or SQL batch code.</param>
public static Result ExecGo(ExecArgument procOrBatch)
{
return(Call <Result>(Assembly.GetCallingAssembly(), (ca) =>
{
if (procOrBatch == null)
{
_Throw(QueryTalkExceptionType.ArgumentNull, "procOrBatch", Wall.Text.Method.ExecGo);
}
var root = new d();
var cpass = PassChainer.Create(root, procOrBatch);
var connectable = Reader.GetConnectable(ca, cpass);
return Reader.LoadAll(connectable);
}));
}
/// <summary>
/// Executes a stored procedure or SQL batch asynchronously.
/// </summary>
/// <param name="procOrBatch">Is a stored procedure or SQL batch.</param>
/// <param name="onCompleted">A delegate method that is called when the asynchronous operation completes.</param>
/// <returns>The object of the asynchronous operation.</returns>
public static Async ExecGoAsync(ExecArgument procOrBatch, Action <Result> onCompleted = null)
{
return(Call <Async>(Assembly.GetCallingAssembly(), (ca) =>
{
if (procOrBatch == null)
{
_Throw(QueryTalkExceptionType.ArgumentNull, "procOrBatch", Wall.Text.Method.ExecGoAsync);
}
var root = new d();
var cpass = PassChainer.Create(root, procOrBatch);
var connectable = Reader.GetConnectable(ca, cpass);
connectable.OnAsyncCompleted = onCompleted;
return Reader.LoadAllAsync(connectable);
}));
}
// used for inlining: to pass a procedure
internal ParameterArgument(ExecArgument arg)
: this(arg as Chainer)
{
SetArgType(arg);
}
