protected virtual void Dispose(bool isDisposing) { if (!_isDisposed) { if (isDisposing) { if (_connectionProvider != null) { ((IDisposable)_connectionProvider).Dispose(); _connectionProvider = null; } } } _isDisposed = true; }
///<Summary> ///Delete all by foreign key ///This method deletes all rows in the table technician with a given foreign key ///</Summary> ///<returns> ///void ///</returns> ///<parameters> ///HelpDesk_TxConnectionProvider connectionProvider, Int32? roleid ///</parameters> public static void DeleteAllByRoleid(HelpDesk_TxConnectionProvider connectionProvider, Int32?roleid) { SqlCommand command = new SqlCommand(); command.CommandText = InlineProcs.ctprtechnician_DeleteAllByRoleid; command.CommandType = CommandType.Text; command.Connection = connectionProvider.Connection; command.Transaction = connectionProvider.CurrentTransaction; try { command.Parameters.Add(new SqlParameter("@roleid", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, (object)roleid ?? (object)DBNull.Value)); command.ExecuteNonQuery(); } catch { throw; } finally { command.Dispose(); } }