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