/*
* /// <summary>
* /// Bind the statement parameters to the key-value pairs in <paramref name="pairs"/>.
* /// </summary>
* /// <remarks>
* /// Bind parameters may be <see langword="null"/>, any numeric type, or an instance of <see cref="string"/>,
* /// byte[], or <see cref="Stream"/>.
* /// </remarks>
* /// <param name="This">The statement.</param>
* /// <param name="pairs">An enumerable of keyvalue pairs keyed by bind parameter name.</param>
* internal static void Bind(this IStatement This, IEnumerable<KeyValuePair<string,object>> pairs)
* {
* Contract.Requires(This != null);
* Contract.Requires(pairs != null);
*
* foreach (var kvp in pairs)
* {
* This.BindParameters[kvp.Key].Bind(kvp.Value);
* }
* }*/
/// <summary>
/// Executes the <see cref="IStatement"/> with provided bind parameter values.
/// </summary>
/// <remarks>Note that this method resets and clears the existing bindings, before
/// binding the new values and executing the statement.</remarks>
/// <param name="This">The statements.</param>
/// <param name="values">The position indexed values to bind.</param>
public static void Execute(this IStatement This, params object[] values)
{
Contract.Requires(This != null);
Contract.Requires(values != null);
This.Reset();
This.ClearBindings();
This.Bind(values);
This.MoveNext();
}
/// <summary>
/// Queries the database using the provided IStatement and provided bind variables.
/// </summary>
/// <param name="This">The statements.</param>
/// <param name="values">The position indexed values to bind.</param>
/// <returns>An <see cref="IEnumerable<T>"/> of rows in the result set.</returns>
public static IEnumerable <IReadOnlyList <IResultSetValue> > Query(
this IStatement This,
params object[] values)
{
Contract.Requires(This != null);
Contract.Requires(values != null);
return(new DelegatingEnumerable <IReadOnlyList <IResultSetValue> >(() =>
{
This.Reset();
This.ClearBindings();
This.Bind(values);
return This.Enumerate();
}));
}