/// <summary>
/// Add an input parameter initialised with the value and type to the
/// specified <see cref="DbCommand" />.
/// </summary>
public DbParameter AddParameter(DbCommand dbCommand, String name, Object value, AdoDbType type)
{
if (innerResourceProvider == null)
{
throw new NotSupportedException(RM.Get_Error_ResourceProviderNotInitialised());
}
return(innerResourceProvider.AddParameter(dbCommand, name, value, type));
}
/// <summary>
/// Thin wrapper around
/// <see cref="IAdoResourceProvider.AddParameter(DbCommand,string,object,AdoDbType)" />
/// that provides the connection to use for derived implementations.
/// </summary>
protected DbParameter AddParameter(DbCommand dbCommand, String name, object value, AdoDbType type)
{
return(_resourceProvider.AddParameter(dbCommand, name, value, type));
}
/// <summary>
/// Insert a new completed scope into the persistence store.
/// </summary>
/// <param name="instanceId"></param>
/// <param name="scopeId"></param>
/// <param name="state"></param>
public void InsertCompletedScope(Guid instanceId, Guid scopeId, byte[] state)
{
using (DbCommand dbCommand = resourceProvider.CreateCommand(dbConnection, nameResolver.ResolveCommandName(CommandNames.InsertCompletedScope), CommandType.StoredProcedure))
{
resourceProvider.AddParameter(dbCommand,
nameResolver.ResolveParameterName(CommandNames.InsertCompletedScope,
ParameterNames.InstanceId), instanceId, AdoDbType.Guid);
resourceProvider.AddParameter(dbCommand,
nameResolver.ResolveParameterName(CommandNames.InsertCompletedScope,
ParameterNames.ScopeId), scopeId, AdoDbType.Guid);
resourceProvider.AddParameter(dbCommand,
nameResolver.ResolveParameterName(CommandNames.InsertCompletedScope,
ParameterNames.State), state, AdoDbType.Binary);
dbCommand.ExecuteNonQuery();
}
}