public static CachePagesTable GetUnexpiredPageImage(string pageType, string pageKey, DateTime minDateStamp, int commandTimeout = -1) { var cmdText = SelectAllCommandText + " WHERE PageType=@PageType AND PageKey=@PageKey AND DateStamp>=@DateStamp"; var cmd = VoteCacheLocalDb.GetCommand(cmdText, commandTimeout); VoteCacheLocalDb.AddCommandParameter(cmd, "PageType", pageType); VoteCacheLocalDb.AddCommandParameter(cmd, "PageKey", pageKey); VoteCacheLocalDb.AddCommandParameter(cmd, "DateStamp", minDateStamp); return(FillTable(cmd, CachePagesTable.ColumnSet.All)); }
public static void Upsert(string pageType, string pageKey, DateTime dateStamp, byte[] pageImage, int commandTimeout = -1) { const string cmdText = "INSERT INTO CachePages (PageType,PageKey,DateStamp,PageImage)" + " VALUES (@PageType,@PageKey,@DateStamp,@PageImage)" + " ON DUPLICATE KEY UPDATE DateStamp=VALUES(DateStamp),PageImage=VALUES(PageImage)"; var cmd = VoteCacheLocalDb.GetCommand(cmdText, commandTimeout); VoteCacheLocalDb.AddCommandParameter(cmd, "PageType", pageType); VoteCacheLocalDb.AddCommandParameter(cmd, "PageKey", pageKey); VoteCacheLocalDb.AddCommandParameter(cmd, "DateStamp", dateStamp); VoteCacheLocalDb.AddCommandParameter(cmd, "PageImage", pageImage); VoteCacheLocalDb.ExecuteNonQuery(cmd); }