/// <summary>
/// Creates an ADO command initialised with the specified connection
/// and command text. This uses the default command type.
/// </summary>
public DbCommand CreateCommand(DbConnection dbConnection, String commandText)
{
if (innerResourceProvider == null)
{
throw new NotSupportedException(RM.Get_Error_ResourceProviderNotInitialised());
}
return(associateCommandWithTransaction(
innerResourceProvider.CreateCommand(dbConnection,
commandText)));
}
/// <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();
}
}
/// <summary>
/// Thin wrapper around
/// <see cref="IAdoResourceProvider.CreateCommand(DbConnection,string)" />
/// that provides the connection to use for derived implementations.
/// </summary>
protected DbCommand CreateCommand(String commandText)
{
return(_resourceProvider.CreateCommand(_dbConnection, commandText));
}
/// <summary>
/// Thin wrapper around
/// <see cref="IAdoResourceProvider.CreateCommand(DbConnection,string)" />
/// that provides the connection to use for derived implementations.
/// </summary>
protected DbCommand CreateCommand(string commandText)
{
return(resourceProvider.CreateCommand(this.dbConnection, commandText));
}