| # 6. Inheritance So far we have always been working with the concrete (i.e. most specific type of an object. What about subclassing and interfaces? To explore this, we will differentiate between different kinds of sensors.
`using System; namespace com.db4o.f1.chapter4 { public class SensorReadout { DateTime _time; Car _car; string _description; public SensorReadout(DateTime time, Car car, string description) { _time = time; _car = car; _description = description; } public Car Car { get { return _car; } } public DateTime Time { get { return _time; } } public string Description { get { return _description; } } override public string ToString() { return string.Format("{0}:{1}:{2}", _car, _time, _description); } } }`
`using System; namespace com.db4o.f1.chapter4 { public class TemperatureSensorReadout : SensorReadout { double _temperature; public TemperatureSensorReadout(DateTime time, Car car, string description, double temperature) : base(time, car, description) { _temperature = temperature; } public double Temperature { get { return _temperature; } } override public string ToString() { return string.Format("{0} temp: {1}", base.ToString(), _temperature); } } }`
`using System; namespace com.db4o.f1.chapter4 { public class PressureSensorReadout : SensorReadout { double _pressure; public PressureSensorReadout(DateTime time, Car car, string description, double pressure) : base(time, car, description) { _pressure = pressure; } public double Pressure { get { return _pressure; } } override public string ToString() { return string.Format("{0} pressure: {1}", base.ToString(), _pressure); } } }`
Our car's snapshot mechanism is changed accordingly.
`using System; using System.Collections; namespace com.db4o.f1.chapter4 { public class Car { string _model; Pilot _pilot; IList _history; public Car(string model) { _model = model; _pilot = null; _history = new ArrayList(); } public Pilot Pilot { get { return _pilot; } set { _pilot = value; } } public string Model { get { return _model; } } public SensorReadout[] GetHistory() { SensorReadout[] history = new SensorReadout[_history.Count]; _history.CopyTo(history, 0); return history; } public void Snapshot() { _history.Add(new TemperatureSensorReadout(DateTime.Now, this, "oil", PollOilTemperature())); _history.Add(new TemperatureSensorReadout(DateTime.Now, this, "water", PollWaterTemperature())); _history.Add(new PressureSensorReadout(DateTime.Now, this, "oil", PollOilPressure())); } protected double PollOilTemperature() { return 0.1*_history.Count; } protected double PollWaterTemperature() { return 0.2*_history.Count; } protected double PollOilPressure() { return 0.3*_history.Count; } override public string ToString() { return string.Format("{0}[{1}]/{2}", _model, _pilot, _history.Count); } } }`
## 6.1. Storing Our setup code has not changed at all, just the internal workings of a snapshot.
`[storeFirstCar] Car car1 = new Car("Ferrari"); Pilot pilot1 = new Pilot("Michael Schumacher", 100); car1.Pilot = pilot1; db.Set(car1);`
`[storeSecondCar] Pilot pilot2 = new Pilot("Rubens Barrichello", 99); Car car2 = new Car("BMW"); car2.Pilot = pilot2; car2.Snapshot(); car2.Snapshot(); db.Set(car2);`
## 6.2. Retrieving db4o will provide us with all objects of the given type. To collect all instances of a given class, no matter whether they are subclass members or direct instances, we just provide a corresponding prototype.
`[retrieveTemperatureReadoutsQBE] SensorReadout proto = new TemperatureSensorReadout(DateTime.MinValue, null, null, 0.0); ObjectSet result = db.Get(proto); ListResult(result);`
OUTPUT: 4 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.8 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.30000000000000004 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.2 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.0

`[retrieveAllSensorReadoutsQBE] SensorReadout proto = new SensorReadout(DateTime.MinValue, null, null); ObjectSet result = db.Get(proto); ListResult(result);`

OUTPUT: 6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 1.5 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.8 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.30000000000000004 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 0.6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.2 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.0

This is one more situation where QBE might not be applicable: What if the given type is an interface or an abstract class? Well, there's a little trick to keep in mind: Type objects receive special handling with QBE.

`[retrieveAllSensorReadoutsQBEAlternative] ObjectSet result = db.Get(typeof(SensorReadout)); ListResult(result);`

OUTPUT: 6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 1.5 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.8 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.30000000000000004 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 0.6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.2 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.0

And of course there's our SODA API:

`[retrieveAllSensorReadoutsQuery] Query query = db.Query(); query.Constrain(typeof(SensorReadout)); ObjectSet result = query.Execute(); ListResult(result);`

OUTPUT: 6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 1.5 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.8 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.30000000000000004 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil pressure : 0.6 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : water temp : 0.2 BMW[Rubens Barrichello/99]/6 : Wed Jul 05 10:33:26 CEST 2006 : oil temp : 0.0

## 6.3. Updating and deleting

is just the same for all objects, no matter where they are situated in the inheritance tree.
Just like we retrieved all objects from the database above, we can delete all stored objects to prepare for the next chapter.

`[deleteAll] ObjectSet result = db.Get(typeof(Object)); foreach (object item in result) { db.Delete(item); }`

## 6.4. Conclusion

Now we have covered all basic OO features and the way they are handled by db4o. We will complete the first part of our db4o walkthrough in the next chapter by looking at deep object graphs, including recursive structures.

## 6.5. Full source

`﻿using System; using System.IO; using com.db4o; using com.db4o.f1; using com.db4o.query; namespace com.db4o.f1.chapter4 { public class InheritanceExample : Util { public static void Main(string[] args) { File.Delete(Util.YapFileName); ObjectContainer db = Db4o.OpenFile(Util.YapFileName); try { StoreFirstCar(db); StoreSecondCar(db); RetrieveTemperatureReadoutsQBE(db); RetrieveAllSensorReadoutsQBE(db); RetrieveAllSensorReadoutsQBEAlternative(db); RetrieveAllSensorReadoutsQuery(db); RetrieveAllObjects(db); } finally { db.Close(); } } public static void StoreFirstCar(ObjectContainer db) { Car car1 = new Car("Ferrari"); Pilot pilot1 = new Pilot("Michael Schumacher", 100); car1.Pilot = pilot1; db.Set(car1); } public static void StoreSecondCar(ObjectContainer db) { Pilot pilot2 = new Pilot("Rubens Barrichello", 99); Car car2 = new Car("BMW"); car2.Pilot = pilot2; car2.Snapshot(); car2.Snapshot(); db.Set(car2); } public static void RetrieveAllSensorReadoutsQBE(ObjectContainer db) { SensorReadout proto = new SensorReadout(DateTime.MinValue, null, null); ObjectSet result = db.Get(proto); ListResult(result); } public static void RetrieveTemperatureReadoutsQBE(ObjectContainer db) { SensorReadout proto = new TemperatureSensorReadout(DateTime.MinValue, null, null, 0.0); ObjectSet result = db.Get(proto); ListResult(result); } public static void RetrieveAllSensorReadoutsQBEAlternative(ObjectContainer db) { ObjectSet result = db.Get(typeof(SensorReadout)); ListResult(result); } public static void RetrieveAllSensorReadoutsQuery(ObjectContainer db) { Query query = db.Query(); query.Constrain(typeof(SensorReadout)); ObjectSet result = query.Execute(); ListResult(result); } public static void RetrieveAllObjects(ObjectContainer db) { ObjectSet result = db.Get(new object()); ListResult(result); } } }`

--
generated by Doctor courtesy of db4objects Inc.