Takes an exception that was thrown from TestConnection and attempts to correct the error that was encountered. If it's likely to have succeeded then returns true.

If the database file is missing or entirely empty then this method creates the file and pre-populates the tables with roughly the same records that BaseStation prepopulates a new database with.

Deletes an existing aircraft record.

Deletes an existing flight record. Ignores the aircraft record attached to the flight (if any).

Deletes an existing location record.

Deletes the record for a session. This automatically deletes all flights associated with the session.

Deletes an existing SystemEvents record.

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

Ends a transaction. Ending a nested transaction has no effect.

Returns the first aircraft with the ICAO24 code passed across.

Retrieves an aircraft record by its identifier.

Returns the first aircraft with the registration passed across.

Returns every aircraft record in the database.

Returns the number of flights that match the criteria passed across.

Returns the number of flight records that match the criteria passed across.

Returns all of the records from BaseStation's DBHistory table.

Returns the single DBInfo record in BaseStation's DBInfo table. Note that this has no key.

Retrieves a flight record from the database by its ID number. This does not read the associated aircraft record.

Returns all flights, or a subset of all flights, that match the criteria passed across.

Returns a list of every flight, or a subset of every flight, that matches the criteria passed across.

Returns all of the locations from BaseStation's Locations table.

Returns aircraft records and counts of flights for many ICAO24 codes simultaneously.

Returns aircraft records for many ICAO24 codes simultaneously.

Fetches an aircraft by its ICAO code. If there is no record for the aircraft then the createNewAircraftFunc method is called to build a new record, and that is inserted.

Returns all of the sessions from BaseStation's Sessions table.

Returns the entire content of the SystemEvents table.

Inserts a new aircraft record and fills AircraftID with the identifier of the record.

Inserts a new flight record and assigns the unique identifier of the new record to the FlightID property. The AircraftID property must be filled with the identifier of an existing aircraft record.

Inserts a new record in the database for the location passed across and sets the LocationID to the identifier of the new record.

Inserts a record in the Sessions table, setting SessionID to the identifier of the new record.

Inserts a new SystemEvents record and sets the SystemEventsID to the identifier of the new record.

Does the same as RecordMissingAircraft(String) but for many ICAOs simultaneously.

Records a missing aircraft record.

Rolls back a transaction. Rolling back a nested transaction rolls back all transactions.

Begins a new transaction. Nesting transactions is allowed.

Returns true if a connection could be made to FileName, false if it could not. If it could be made then the connection is left open.

Updates an existing aircraft record.

Updates the Mode-S country for an aircraft.

Updates an existing flight record. Ignores the aircraft record attached to the flight (if any).

Updates an existing location record.

Updates the record for a session.

Updates an existing SystemEvents record.

Creates or updates an aircraft record.

Does the same as UpsertAircraftByCode(String, FuncBaseStationAircraft, BaseStationAircraft) but for many ICAOs.