db4o Developer Community

Hi all,

if you ever play around with the formula 1 tutorial. Have you every tried such a query;

Find car where Car.Pilot.point = 100

I don't know how to convert such a query into SODA, any hints are greatly appreciated!

/Meng

Meng wrote:

Have you every tried such a query; Find car where Car.Pilot.point = 100 I don't know how to convert such a query into SODA, any hints are greatly appreciated!

It's just like retrieveCarByPilotNameQuery() in the 'Structured Objects' tutorial chapter.

query.constrain(Car.class);
query
   .descend("pilot")
   .descend("points")
   .constrain(new Integer(100));

Best regards,
Patrick

Thank you Partick, I get to like this fantastic software more and more now. it is so elegant solution for object orient computing.

I recommend you Native Queries if you are not worry about performance issues.

code would be like that:

IList<Car> result = container.Query<Car>(delegate(Car c){return c.Pilot.Point==100;});

 

seems nice, doesnt it?