public static int DeleteExpiredTransactions(
DateTime expiration, int commandTimeout = -1)
{
const string cmdText =
"DELETE FROM CacheInvalidation WHERE CacheTimeStamp<@Expiration";
var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout);
VoteCacheDb.AddCommandParameter(cmd, "Expiration", expiration);
return(VoteCacheDb.ExecuteNonQuery(cmd));
}
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 = VoteCacheDb.GetCommand(cmdText, commandTimeout);
VoteCacheDb.AddCommandParameter(cmd, "PageType", pageType);
VoteCacheDb.AddCommandParameter(cmd, "PageKey", pageKey);
VoteCacheDb.AddCommandParameter(cmd, "DateStamp", dateStamp);
VoteCacheDb.AddCommandParameter(cmd, "PageImage", pageImage);
VoteCacheDb.ExecuteNonQuery(cmd);
}
