public DBRevision GetRevision (string lane, int revision)
{
using (IDbCommand cmd = CreateCommand ()) {
cmd.CommandText = "SELECT * from revisions where lane = @lane AND revision = @revision";
DB.CreateParameter (cmd, "lane", lane);
DB.CreateParameter (cmd, "revision", revision.ToString ());
using (IDataReader reader = cmd.ExecuteReader ()) {
if (!reader.Read ())
return null;
if (reader.IsDBNull (0))
return null;
DBRevision rev = new DBRevision ();
rev.Load (reader);
return rev;
}
}
}