public List<DBLane> GetAllLanes ()
{
List<DBLane> result = new List<DBLane> ();
using (IDbCommand cmd = CreateCommand ()) {
cmd.CommandText = "SELECT * FROM Lane ORDER BY lane";
using (IDataReader reader = cmd.ExecuteReader ()) {
while (reader.Read ()) {
result.Add (new DBLane (reader));
}
}
}
return result;
}