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; }