/// <summary> /// Using Indexes /// </summary> public void Step11() { // Open the database ODB odb = null; try { odb = ODBFactory.Open(ODB_NAME); String[] fieldNames = { "name" }; odb.GetClassRepresentation(typeof(Sport)).AddUniqueIndexOn("sport-index", fieldNames, true); odb.Close(); odb = ODBFactory.Open(ODB_NAME); IQuery query = new CriteriaQuery(typeof(Sport), Where.Equal("name", "volley-ball")); Objects <Sport> sports = odb.GetObjects <Sport>(query); Console.WriteLine("\nStep 11 : Using index"); int i = 1; // display each object while (sports.HasNext()) { Console.WriteLine((i++) + "\t: " + sports.Next()); } } finally { if (odb != null) { // Close the database odb.Close(); } } }