public static DbSchemaChange GetByNo(DbConnector dbConn, uint changeNo) {
dbConn.SetQueryText(string.Format("select ChangeID, ChangeNo, ScriptName, DateInstall from A_SCHEMA_CHANGES_LOG where ChangeNo = {0}", changeNo));
dbConn.Execute();
if (!dbConn.NextRow()) {
return null;
}
var sch = new DbSchemaChange();
sch.FromDb(dbConn);
return sch;
}
public static DbSchemaChange GetLast(DbConnector dbConn) {
dbConn.SetQueryText("select ChangeID, ChangeNo, ScriptName, DateInstall from A_SCHEMA_CHANGES_LOG order by ChangeNo desc");
dbConn.Execute();
if (!dbConn.NextRow()) {
return null;
}
var sch = new DbSchemaChange();
sch.FromDb(dbConn);
return sch;
}
