/// <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();
}
}
}
