/// <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(); } }