public int GetLastRevision (string lane)
{
using (IDbCommand cmd = CreateCommand ()) {
DBLane l = LookupLane (lane);
cmd.CommandText = "SELECT max (CAST (revision AS int)) FROM Revision WHERE lane_id = @lane_id";
DB.CreateParameter (cmd, "lane_id", l.id);
using (IDataReader reader = cmd.ExecuteReader ()) {
if (!reader.Read ())
return 0;
if (reader.IsDBNull (0))
return 0;
return reader.GetInt32 (0);
}
}
}